A SQL script to identify all the FKs referencing a table

Asked Jun 19 '12 at 10:14

Active Jun 19 '12 at 10:23

Viewed 200 times

Possible Duplicate:
How can I list all foreign keys referencing a given table in SQL Server 2005?

I'm trying to use Information_Schema to find all the FKs referencing a particular table. However I can only find the FKs that table holds onto others in the Constraint_Column_Usage and Constraint_Table_Usage tables.

I'm using SQL Server 2008

How can I do this?

edited May 23 '17 at 12:20

Community

asked Jun 19 '12 at 10:14

Liath

9,913
9
51
81

Thanks - that looks like exactly what I'm looking for - I've voted to close as dup – Liath Jun 19 '12 at 10:20

A SQL script to identify all the FKs referencing a table

0 Answers0