How to Find Foreign Key Constraints in SQL Server

Just use the sp_fkeys stored procedure.

Syntax

sp_fkeys [@pktable_name =] ‘pktable_name’
[,[@pktable_owner =] ‘pktable_owner’]
[,[@pktable_qualifier =] ‘pktable_qualifier’]
{, [@fktable_name =] ‘fktable_name’}
[,[@fktable_owner =] ‘fktable_owner’]
[,[@fktable_qualifier =] ‘fktable_qualifier’]


Full write-up of the syntax

My Search Queries:

  1. “sp_fkeys” OR “sp_foreignkeys”
  2. how to find foreign key (relationships OR constraints) in sql server
  3. script to find foreign key columnscript to find foreign key column
  4. sql script how do you find the column that a foreign key references

Posted by Greg Pinero (Primary Searcher) on Aug 31st, 2006 and is filed under win32.

Both comments and pings are currently closed.

Add this post to Del.icio.us - Digg

Comments are closed.