| Column ID | Column name | Data type | Length | Precision | NULL | Description |
|
| 1 | OWNER | VARCHAR2 | 30 | (null) | N | Owner of the table |
| 2 | CONSTRAINT_NAME | VARCHAR2 | 30 | (null) | N | Name associated with constraint definition |
| 3 | CONSTRAINT_TYPE | VARCHAR2 | 1 | (null) | Y | Type of constraint definition |
| 4 | TABLE_NAME | VARCHAR2 | 30 | (null) | N | Name associated with table with constraint definition |
| 5 | SEARCH_CONDITION | LONG | 0 | (null) | Y | Text of search condition for table check |
| 6 | R_OWNER | VARCHAR2 | 30 | (null) | Y | Owner of table used in referential constraint |
| 7 | R_CONSTRAINT_NAME | VARCHAR2 | 30 | (null) | Y | Name of unique constraint definition for referenced table |
| 8 | DELETE_RULE | VARCHAR2 | 9 | (null) | Y | The delete rule for a referential constraint |
| 9 | STATUS | VARCHAR2 | 8 | (null) | Y | Enforcement status of constraint - ENABLED or DISABLED |
| 10 | DEFERRABLE | VARCHAR2 | 14 | (null) | Y | Is the constraint deferrable - DEFERRABLE or NOT DEFERRABLE |
| 11 | DEFERRED | VARCHAR2 | 9 | (null) | Y | Is the constraint deferred by default - DEFERRED or IMMEDIATE |
| 12 | VALIDATED | VARCHAR2 | 13 | (null) | Y | Was this constraint system validated? - VALIDATED or NOT VALIDATED |
| 13 | GENERATED | VARCHAR2 | 14 | (null) | Y | Was the constraint name system generated? - GENERATED NAME or USER NAME |
| 14 | BAD | VARCHAR2 | 3 | (null) | Y | Creating this constraint should give ORA-02436. Rewrite it before 2000 AD. |
| 15 | RELY | VARCHAR2 | 4 | (null) | Y | If set, this flag will be used in optimizer |
| 16 | LAST_CHANGE | DATE | 7 | (null) | Y | The date when this column was last enabled or disabled |
| 17 | INDEX_OWNER | VARCHAR2 | 30 | (null) | Y | The owner of the index used by this constraint |
| 18 | INDEX_NAME | VARCHAR2 | 30 | (null) | Y | The index used by this constraint |
| 19 | INVALID | VARCHAR2 | 7 | (null) | Y | NULL - oracleabc.com |
| 20 | VIEW_RELATED | VARCHAR2 | 14 | (null) | Y | NULL - oracleabc.com |