The ALL_CONSTRAINTS view provides the information about the constraints placed on tables accessible by the current user.
Parameter | Type | Description |
---|---|---|
owner | TEXT | The username of the owner to which the constraint belongs. |
schema_name | TEXT | The name of the schema to which the constraint belongs. |
constraint_name | TEXT | The name of the constraint. |
constraint_type | TEXT | The type of the constraint. Valid values:
|
table_name | TEXT | The name of the table to which the constraint belongs. |
search_condition | TEXT | The search condition that applies to a check constraint. |
r_owner | TEXT | The owner of a table referenced by a referential constraint. |
r_constraint_name | TEXT | The name of the constraint definition for a referenced table. |
delete_rule | TEXT | The delete rule for a referential constraint. Valid values:
|
deferrable | BOOLEAN | Indicates if the constraint is deferrable. Valid values: T and F. |
deferred | BOOLEAN | Indicates if the constraint has been deferred. Valid values: T and F. |
index_owner | TEXT | The username of the owner to which the index belongs. |
index_name | TEXT | The name of the index. |
constraint_def | TEXT | The definition of the constraint. |