Quick tip to quickly find all FKs for a certain table

October 6, 2015
You can find all FK for a certain table in SQL Server with the following query :

SELECT * FROM sys.foreign_keys WHERE referenced_object_id = object_id('YourTable')




© Marius Gheorghe