SQL Server Forums - Get relationship via SQL

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Programming

Get relationship via SQL

New Topic

Reply to Topic

Printer Friendly

Author

Topic

vishal_7
Posting Yak Master

127 Posts

Posted - 08/30/2005 : 14:46:16

Hey,

is it possible to get the relationship of a table via sql? Like I need to know which relations the table t has. Is that possible?

Thanks

TG
Flowing Fount of Yak Knowledge

USA
5467 Posts

Posted - 08/30/2005 : 16:36:20

One way is from a query analyzer window: sp_help <tableName>
Gives you a lot of info about the table including foreign Keys and tables referenced by foreign keys. (relationships are defined by foreign keys)

Be One with the Optimizer
TG

robvolk
Most Valuable Yak

USA
15557 Posts

Posted - 08/30/2005 : 18:54:01

You can also try selecting from INFORMATION_SCHEMA.TABLE_CONSTRAINTS and INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS, these give you the same info as sp_help but in a different format.

vishal_7
Posting Yak Master

127 Posts

Posted - 08/31/2005 : 09:56:22

thanks guys, I will try it out and report when there are any probs.

vishal_7
Posting Yak Master

127 Posts

Posted - 08/31/2005 : 10:42:37

Isnt sp_fkeys much better for that purpose?

madhivanan
Premature Yak Congratulator

India
22460 Posts

Posted - 08/31/2005 : 10:46:23