Thursday, December 2, 2010

SQLSERVER : Get all Foreign key relationships of all tables in a database

Show all Foreign key relationships of all tables in a database:

SELECT
*
FROM INFORMATION_SCHEMA
.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE
= 'FOREIGN KEY'



SELECT
*
FROM INFORMATION_SCHEMA
.CONSTRAINT_TABLE_USAGE
WHERE CONSTRAINT_NAME IN
( SELECT CONSTRAINT_NAME
FROM INFORMATION_SCHEMA
.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE
= 'FOREIGN KEY' )
SELECT
*
FROM INFORMATION_SCHEMA
.CONSTRAINT_COLUMN_USAGE
WHERE CONSTRAINT_NAME IN
( SELECT CONSTRAINT_NAME
FROM INFORMATION_SCHEMA
.TABLE_CONSTRAINTS
WHERE CONSTRAINT_TYPE
= 'FOREIGN KEY' )

No comments: