那就辛苦一点自己编程找吧。系统--某个表上的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';
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';