getting composite foreign keys

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

getting composite foreign keys

Author

Topic

maifs
Yak Posting Veteran

57 Posts

Posted - 2010-04-30 : 05:52:10

how can i get composite foreign key records against a primary key?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-05-01 : 01:03:31

have a look at sys.foreign_keys table

http://technet.microsoft.com/en-us/library/ms189807.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-05-07 : 10:06:46

EXEC sp_fkeys 'your_table'

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources