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:

Rename column SQL Server
Search text in all stored procedures in SQL Server
How to find the first missing value in a series in MS SQL
How to solve “A cursor with the name already exists” problem?
How to return only the Date part from SQL Server DateTime datatype
Post Views: 90

Leave a Reply

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

Most Viewed Posts