Find Check Constraints and return Check_Clause Showing Check Descriptions

Jayakumars
Posted by Jayakumars under SQL Server category on | Points: 40 | Views : 879
12.-- Find Check Constraints and return Check_Clause Showing Check Descriptions--
Select CONSTRAINT_CATALOG as Dbname,CONSTRAINT_NAME,CHECK_CLAUSE
FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS

Comments or Responses

Login to post response