SQL List all foreign keys referencing to a given table

Lets say

TRUNCATE TABLE SomeTable 

gives you error

Cannot truncate table 'SomeTable' because it is being referenced by a FOREIGN KEY constraint.

To find out which tables are referencing to it run

EXEC sp_help 'SomeTable'

Leave a Reply

Your email address will not be published. Required fields are marked *