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:

Get the User Name and Domain Name from an Email Address in SQL
Average of all values in a column that are not zero in SQL
How to Alter a Computed Column in SQL?
View the Definition of a Stored Procedure in SQL
Get the First and Last Word from a String or Sentence in SQL
Post Views: 90

Leave a Reply

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

Most Viewed Posts