Post reply

Report of indexes, FK''s, PK''s required as we get in ERWin

  • February 10, 2005 at 8:06 am

    #92235

    Is there any way to get report on

    List of Table and Fields

    List of FK's and PK's

    Fields and the Keys

    Sanjay Masawan

  • February 10, 2005 at 8:09 am

    #541589

    Research SYSOBJECTS, SYSINDEXES, SYSCOLUMNS, SYSCONSTRAINTS....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • February 10, 2005 at 8:30 am

    #541592

    Isnt there any Report instead os firing queries

  • February 10, 2005 at 9:50 am

    #541612

    You'll have to do some work because there's no premade report. But this can get you started :

    Select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS

    Select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE

    Those views are all located in the master database, run it just like and sp_* proc from any db you need to extract info from.

  • February 11, 2005 at 10:14 am

    #541842

    Go to BOL - select the index tab - and enter sp_help.

    This may not give you exactly what you want, but it may be a good starting point for individual objects (and the base code you'll need to try and recreate the same reports for multiple objects in a database).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply