TSQL How to see contents of Check Constraint on SQLServer

Question

Is there a TSQL script that will allow me to see the contents of a constraint. I found a question regarding Oracle but I need a TSQL script.

http://stackoverflow.com/questions/2686353/how-to-see-contents-of-check-constraint-on-oracle

I am aware of sys.check_constraints, however, the 'definition' comes back null for all objects.

Select * from sys.check_constraints

Answer 1

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

Answer 2

Another way

for check constraints

select definition,name
 from sys.check_constraints

for default constraints

select definition,name
 from sys.default_constraints

and yet another way

 SELECT object_definition(OBJECT_ID(CONSTRAINT_NAME)),* 
 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
 where CONSTRAINT_TYPE <> 'PRIMARY KEY'

Answer 3

To have any check constraints, you're going to need objects of this type.

select *
from sys.objects
where sys.objects.type = 'C'

check_constraints