EXEC sp_fkeys 'TableName'
You can also specify the schema:
EXEC sp_fkeys @pktable_name = 'TableName', @pktable_owner = 'dbo'
Find numbers with more than two decimal places in SQL
How to find records based on CAPITAL and small letters in SQL Query?
How to solve “A cursor with the name already exists” problem?
Search text in all stored procedures in SQL Server
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...