其他方式
用于检查约束
select definition,name from sys.check_constraints
对于默认约束
select definition,name from sys.default_constraints
还有另一种方式
SELECt object_definition(OBJECT_ID(CONSTRAINT_NAME)),* FROM INFORMATION_SCHEMA.TABLE_ConSTRAINTS where CONSTRAINT_TYPE <> 'PRIMARY KEY'
