How can I list all foreign keys referencing a given table in SQL Server?

by

Not sure why no one suggested but I use sp_fkeys to query foreign keys for a given table:

EXEC sp_fkeys 'TableName'

You can also specify the schema:

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

Without specifying the schema, the docs state the following:

If pktable_owner is not specified, the default table visibility rules
of the underlying DBMS apply.

In SQL Server, if the current user owns a table with the specified
name, that table’s columns are returned. If pktable_owner is not
specified and the current user does not own a table with the specified
pktable_name, the procedure looks for a table with the specified
pktable_name owned by the database owner. If one exists, that table’s
columns are returned.

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I escape a single quote in SQL Server?
  3. Simple way to transpose columns and rows in SQL?
  4. Only inserting a row if it’s not already there
  5. Unpivot with column name
  6. When should I use CROSS APPLY over INNER JOIN?
  7. get a comma delimited string from rows [duplicate]
  8. Find all tables containing column with specified name – MS SQL Server
  9. SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, =
  10. How to split a single column values to multiple column values?
  11. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  12. Formatting Numbers by padding with leading zeros in SQL Server
  13. When no ‘Order by’ is specified, what order does a query choose for your record set?
  14. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  15. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  16. How do I create a foreign key in SQL Server?
  17. How do I group on continuous ranges
  18. join comma delimited data column
  19. Need to list all triggers in SQL Server database with table name and table’s schema
  20. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  21. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  22. Best equivalent for IsInteger in SQL Server
  23. Store multiple bit values in a single table column
  24. Syntax of for-loop in SQL Server
  25. SQL Server equivalent to MySQL enum data type?
  26. SQL – Call Stored Procedure for each record
  27. SQL – How do I get only the numbers after the decimal?
  28. How to retrieve records for last 30 minutes in MS SQL?
  29. Group consecutive rows of same value using time spans
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment