Script: Getting PK and FK info

• rsharma

  SSCarpal Tunnel

  Points: 4865

  More actions

  July 5, 2001 at 12:00 am

  #63724

  Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/script:gettingpkandfkinfo.asp

• Calvin Lawson

  SSChampion

  Points: 11030

  More actions

  June 5, 2003 at 9:19 pm

  #460087

  This query provides "To" and "From" Fields as well. I like your query for PK constraints...

  select

  so1.Name as FKConstraint,

  so.Name as FromTable,

  sc.Name as FromColumn, so2.Name as ToTable, sc1.Name as ToColumn

  From sysobjects so (nolock)

  JOIN sysforeignkeys fk (nolock) on so.[id] = fk.fkeyid

  join syscolumns sc (nolock) on fk.fkeyid = sc.id and fk.fkey = sc.colid

  JOIN sysobjects so2 (nolock) on fk.rkeyid = so2.id

  join syscolumns sc1 (nolock) on fk.rkeyid = sc1.id and fk.rkey = sc1.colid

  JOIN sysobjects so1 (nolock) on fk.constid = so1.id

  where so.name = X

  Signature is NULL