The domain_constraints view provides information about all domain constraints.
| Column name | Data type | Description |
|---|---|---|
constraint_catalog |
sql_identifier |
The name of the current database that contains the constraint. |
constraint_schema |
sql_identifier |
The name of the schema that contains the constraint. |
constraint_name |
sql_identifier |
The name of the constraint. |
domain_catalog |
sql_identifier |
The name of the current database containing the domain. |
domain_schema |
sql_identifier |
The name of the schema containing the domain. |
domain_name |
sql_identifier |
The name of the domain. |
is_deferrable |
yes_or_no |
Specifies whether the constraint is deferrable (YES) or not (NO). |
initially_deferred |
yes_or_no |
Specifies whether the constraint is initially deferred (YES) or not (NO). |