SQL

List all Foreign Keys referencing a given table in SQL Server

- 20.11.19 | 27.11.19 - ErcanOPAK 
EXEC sp_fkeys 'TableName'

You can also specify the schema:

EXEC sp_fkeys @pktable_name = 'TableName', @pktable_owner = 'dbo'

Related posts:

DATEADD Function in SQL

How to get difference between 2 tables in MSSQL

How to get 'n'th row in Sql Query with OFFSET FETCH NEXT and ROW_NUMBER()

How to get triggers create and update date in SQL

Post Views: 99

Leave a Reply

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