List all default constraints in Azure SQL Database

Article for: SQL Server MySQL MariaDB

The query below lists the default 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,
from sys.default_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
  • definition - SQL expression that defines this default constraint


  • One row: represents one default constraint
  • Scope of rows: the query returns all default constraints in the database (all columns with default constraints)
  • Ordered by constraint name

Sample results

List of default constraints in the AdventureWorksLT database.

There are no comments. Click here to write the first comment.