Here is a short T-SQL snippet showing how to list all constraints in a database matching a given string:
SELECT * FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT' and name like 'DF%'
Here is a short T-SQL snippet showing how to list all constraints in a database matching a given string:
SELECT * FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT' and name like 'DF%'
Comments