sql statement viewing table constraints

[nicolask]

sql statement for viewing table constraints

[r035198x]

You can use sys.objects and filter the results to match your table

SELECT OBJECT_NAME(object_id) AS ConstraintName,
SCHEMA_NAME(schema_id) AS SchemaName,
type_desc AS ConstraintType FROM sys.objects
WHERE type_desc LIKE ‘%CONSTRAINT’ AND OBJECT_NAME(parent_object_id)=‘yourTableName’