List all check constraints in Azure SQL Database

The query below lists the check constraints defined in the database, ordered by constraint name.

Check this query to see them organized by table.


select con.[name] as constraint_name,
    schema_name(t.schema_id) + '.' + t.[name]  as [table],
    col.[name] as column_name,
    case when con.is_disabled = 0
        then 'Active'
        else 'Disabled'
        end as [status]
from sys.check_constraints as con
    left outer join sys.objects as t
        on con.parent_object_id = t.object_id
    left outer join sys.all_columns as col
        on con.parent_column_id = col.column_id
        and con.parent_object_id = col.object_id
order by


  • constraint_name - name of the constraint in the database
  • table - schema and table name for which the constraint is defined
  • column_name - name of the column for column-level check constraints, null for table-level check constraints
  • definition - SQL expression that defines this check constraint
  • status - constraint status
    • 'Active' if constraint is active,
    • 'Disabled' for disabled constraints


  • One row: represents one check constraint
  • Scope of rows: the query returns all check constraints in the database
  • Ordered by: constraint name

Sample results

List of check constraints in the AdventureWorksLT database.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.