The view domain_constraints
contains all
constraints belonging to domains defined in the current database.
Table 32.14. domain_constraints
Columns
Name | Data Type | Description |
---|---|---|
constraint_catalog |
sql_identifier |
Name of the database that contains the constraint (always the current database) |
constraint_schema |
sql_identifier |
Name of the schema that contains the constraint |
constraint_name |
sql_identifier |
Name of the constraint |
domain_catalog |
sql_identifier |
Name of the database that contains the domain (always the current database) |
domain_schema |
sql_identifier |
Name of the schema that contains the domain |
domain_name |
sql_identifier |
Name of the domain |
is_deferrable |
character_data |
YES if the constraint is deferrable, NO if not |
initially_deferred |
character_data |
YES if the constraint is deferrable and initially deferred, NO if not |