34,837
社区成员




--某个表上的default约束
SELECT *
FROM sys.default_constraints
WHERE parent_object_id = OBJECT_ID('Production.Products');
--某个表的check约束
SELECT *
FROM sys.check_constraints
WHERE parent_object_id = OBJECT_ID('Production.Products');
--查询唯一约束(list unique constraints)
SELECT *
FROM sys.key_constraints
WHERE type = 'UQ';
--查询主键(list the primary key constraints in a database)
SELECT *
FROM sys.key_constraints
WHERE type = 'PK';
--查看外键(list foreign keys)
SELECT *
FROM sys.foreign_keys
WHERE name = 'FK_Products_Categories';