TSQL script - To List Primary Keys and Foreign Keys of Database

SELECT OBJECT_NAME(OBJECT_ID) AS ConstraintName,
SCHEMA_NAME(schema_id) AS SchemaName,

OBJECT_NAME(parent_object_id) AS TableName,
type_desc   AS ConstraintType
FROM SYS.OBJECTS
WHERE type_desc IN ('FOREIGN_KEY_CONSTRAINT','PRIMARY_KEY_CONSTRAINT')
GO


No comments: