The view domain_constraints contains all constraints belonging to domains owned by the current user.
Table 31-11. 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 |
