SQL Server - view all foreign key dependencies

I want to find all of the db objects which are dependent on a given table, including other tables which reference the given table through foreign keys. I tried using "sp_depends" and it gives me the sprocs, views, and triggers but doesn't tell me what other tables have foreign keys to the given table. Any help?

5
задан thenoob 9 March 2011 в 16:31
поделиться