Getting all the Foreign Key constraints list of a table in SQL Server
You might need to write a T-SQL Query to retrieve all the foreign key constraints of a given table in SQL Server. For these cases , you can use the sp_fkeys stored procedure.
How to get all the Foreign Key constraints list of a table in SQL Server ?
SQL
x
4
1
USE AdventureWorks2014; 2
GO 3
EXEC sp_fkeys @pktable_name = N'Department' 4
,@pktable_owner = N'HumanResources'; 
Trending Stories
-
SQL Questions Asked in Meesho | SQL Preparation Packet |... youtube.com
-
JOINS in SQL Explained – SQL JOINS Tutorial For Beginners youtube.com
-
SQL Stored Procedures (English) with Amr Elhelw – Tech Vault youtube.com
-
SQL Challenge: Calculate Contest Percentages Like a Pro! youtube.com
-
Web Security 101: How to Defend Against Modern Threats &... youtube.com
Recent Stories
-
SQL Questions Asked in Meesho | SQL Preparation Packet |... youtube.com
-
JOINS in SQL Explained – SQL JOINS Tutorial For Beginners youtube.com
-
SQL Stored Procedures (English) with Amr Elhelw – Tech Vault youtube.com
-
SQL Challenge: Calculate Contest Percentages Like a Pro! youtube.com
-
Web Security 101: How to Defend Against Modern Threats &... youtube.com
Leave Your Comment