How to list the names of check constraint of a table?
How to show the content of a check constraint?

Thanks

---Frank, SQL2005

This should give you a start:

SELECT * FROM sys.check_constraints


Show quoteHide quote

Hi, Frank

This also works in SQL 2000 (as well as SQL 2005):

SELECT CC.CONSTRAINT_NAME, CC.CHECK_CLAUSE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC
INNER JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS CC
ON TC.CONSTRAINT_NAME=CC.CONSTRAINT_NAME
WHERE TABLE_NAME='YourTable' AND CONSTRAINT_TYPE='CHECK'

Razvan

Foreign Key from two tables to one?
Recurring Sequence Help
Best practice BIT or SET('no','yes') ?
How can you prevent the data changes message during editing a row
getting dates between start date and end date