INFORMATION SCHEMA. CHECK CONSTRAINTS
– Identifies check constraints
CREATE VIEW INFORMATION_SCHEMA.CHECK_CONSTRAINTS
AS
SELECT
db_name() AS CONSTRAINT_CATALOG,
schema_name(schema_id) AS CONSTRAINT_SCHEMA,
name AS CONSTRAINT_NAME,
convert(nvarchar(4000), definition) AS CHECK_CLAUSE
FROM
sys.check_constraints