List of Fireign table name, foreign key name, reference field names and Primary table name

• Sanjay Masawan

  Ten Centuries

  Points: 1031

  More actions

  February 18, 2005 at 5:09 am

  #87531

  Hi Champs

  I need a report which displays List of Foreign table name, foreign key name, reference field names and Primary table name

  Please pass on the exact query for it, Thanks in Advance

  Regards

  Sanjay

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  February 18, 2005 at 5:53 am

  #543058

  Please pass on the exact query for it

  I'll leave a bit of work for yourself, okay?

  Either try searching the site here for some script

  or have a look at the INFORMATION_SCHEMA views

  or have a look at sp_pkeys, sp_fkeys.

  Happy coding!

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]