table_constraints

The table_constraints view provides information about table constraints for accessible tables.

Column name Data type Description
constraint_catalog sql_identifier The name of the current database containing the constraint.
constraint_schema sql_identifier The name of the schema containing the constraint.
constraint_name sql_identifier The name of the constraint.
table_catalog sql_identifier The name of the current database containing the table.
table_schema sql_identifier The name of the schema containing the table.
table_name sql_identifier The name of the table.
constraint_type character_data The type of the constraint.
The possible options are:
  • CHECK
  • FOREIGN KEY
  • PRIMARY KEY
  • UNIQUE
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 deferrable and initially deferred (YES) or not (NO).
enforced yes_or_no Specifies whether the constraint is enforced (YES) or not (NO).
nulls_distinct yes_or_no Specifies whether NULL values are considered distinct in a constraint.
The possible options are:
  • YES – NULL values are treated as different from each other.
  • NO – NULL values are treated as equal.
  • NULL – Other types of constraints.