Các phương pháp hiển thị tất cả khóa chính (Primary Key) và khóa ngoại (Foreign Keys) trong 1 database

Phương pháp 1: INFORMATION_SCHEMA

SELECT

    OBJECT_NAME(OBJECT_ID) AS NameofConstraint,

    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')

ORDER BY

    TableName, ConstraintType, NameOfConstraint

GO

Phương pháp 2: sys.objects

SELECT DISTINCT

    Constraint_Name AS [Constraint],

    Table_Schema AS [Schema],

    Table_Name AS [TableName]

FROM

    INFORMATION_SCHEMA.KEY_COLUMN_USAGE

GO