Script: Getting PK and FK info

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Rahul Sharma » Script: Getting PK and FK info

Script: Getting PK and FK info

Rate Topic

Display Mode

Topic Options

Author

Message

rsharma

Posted Thursday, July 05, 2001 12:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, May 11, 2012 3:58 AM
Points: 265, Visits: 184

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

Post #515

Calvin Lawson

Posted Thursday, June 05, 2003 9:19 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, June 21, 2011 10:03 AM
Points: 577, Visits: 102

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

Post #19800

« Prev Topic | Next Topic »

Permissions