-- Display CHECK CONSTRAINT clauses
select a.TABLE_CATALOG, a.TABLE_SCHEMA, a.TABLE_NAME, a.COLUMN_NAME, CHECK_CLAUSE
from information_schema.columns a  
inner join information_schema.constraint_column_usage b 
    on a.column_name = b.column_name and a.table_name = b.table_name 
inner join information_schema.check_constraints c 
    on b.constraint_name = c.constraint_name 
where a.column_default is not null 

-- Display RULEs (clauses not in this table)
SELECT name, object_id
FROM sys.all_objects
WHERE type = 'R'

-- No columns in information_schema.table_constraints show the rule clause
SELECT a.TABLE_CATALOG, a.TABLE_SCHEMA, a.TABLE_NAME, a.COLUMN_NAME, a.CONSTRAINT_NAME
    ,b.CONSTRAINT_TYPE
FROM information_schema.constraint_column_usage a
LEFT OUTER JOIN information_schema.table_constraints b
    ON a.CONSTRAINT_CATALOG = b.CONSTRAINT_CATALOG AND 
        a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA AND
        a.TABLE_CATALOG = b.TABLE_CATALOG AND
        a.TABLE_SCHEMA = b.TABLE_SCHEMA AND
        a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
WHERE b.CONSTRAINT_TYPE IS NULL

SELECT a.name
    ,LTRIM(RIGHT(defn, LEN(defn) - (3 + CHARINDEX(' as ', defn))))
FROM sys.all_objects a
INNER JOIN sys.sql_modules b
    ON a.object_id = b.object_id
CROSS APPLY (SELECT RTRIM(REPLACE(REPLACE(b.definition, CHAR(10), ' '), CHAR(13), ' '))) c (defn)
WHERE a.type = 'R'