Feature
DBA_CONSTRAINTS displays constraints of all tables in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
USER_CONSTRAINTS
ALL_CONSTRAINTS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the constraint. |
| CONSTRAINT_NAME | VARCHAR2(128) | NO | The name of the constraint. |
| CONSTRAINT_TYPE | VARCHAR2(1) | NO | The type of the constraint. Only the NORMAL type is supported at present. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table containing the constraint. |
| SEARCH_CONDITION | VARCHAR2(4000) | NO | The search condition text for a check constraint. |
| R_OWNER | VARCHAR2(128) | NO | The owner of the referenced constraint. |
| R_CONSTRAINT_NAME | VARCHAR2(128) | NO | The name of the referenced constraint. |
| DELETE_RULE | VARCHAR2(9) | NO | The cascading deletion rule for foreign key constraints. |
| STATUS | VARCHAR2(8) | NO | Indicates whether the constraint is enabled or disabled. Valid values: ENABLE and DISABLE. |
| DEFERRABLE | VARCHAR2(14) | NO | Indicates whether the constraint is deferrable. |
| DEFERRED | VARCHAR2(9) | NO | Indicates whether the constraint is deferred or immediate. |
| VALIDATED | VARCHAR2(13) | NO | Indicates whether the constraint is validated. |
| GENERATED | VARCHAR2(14) | NO | Indicates whether the name of the constraint is user-generated or system-generated. |
| BAD | VARCHAR2(3) | NO | At present, this field is not supported and is NULL by default. |
| RELY | VARCHAR2(4) | NO | Indicates whether the constraint is in the RELY state. |
| LAST_CHANGE | DATE | NO | The time when the constraint was last enabled or disabled. |
| INDEX_OWNER | VARCHAR2(128) | NO | The owner of the index on the constraint. |
| INDEX_NAME | VARCHAR2(128) | NO | The name of the index on the constraint. |
| INVALID | VARCHAR2(7) | NO | Indicates whether the constraint is invalid. |
| VIEW_RELATED | VARCHAR2(14) | NO | Indicates whether the constraint is created on a view. |