## MD_CONSTRAINTS

Columns
Constraints
Grants
Statistics
Triggers
Dependencies
Details
Partitions
Indexes

COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | PK | COMMENTS
--- | --- | --- | --- | --- | --- | ---
ID | NUMBER | No | null | 1 | 1 | Primary Key
DELETE_CLAUSE | VARCHAR2(4000 BYTE) | Yes | null | 2 | null | delete option , can be either CASCADE, RESTRICT or NULL
NAME | VARCHAR2(4000 BYTE) | Yes | null | 3 | null | Name of the constraint //OBJECTNAME
CONSTRAINT_TYPE | VARCHAR2(4000 BYTE) | Yes | null | 4 | null | Type of the constraint (e.g. CHECK)
TABLE_ID_FK | NUMBER | No | null | 5 | null | Table on which this constraint exists //PARENTFIELD
REFTABLE_ID_FK | NUMBER | Yes | null | 6 | null | Used in foreign keys - this gives the table that we refer to.
CONSTRAINT_TEXT | CLOB | Yes | null | 7 | null | The text of the constraint
LANGUAGE | VARCHAR2(40 BYTE) | No | null | 8 | null | //PUBLIC
COMMENTS | VARCHAR2(4000 BYTE) | Yes | null | 9 | null | null
SECURITY_GROUP_ID | NUMBER | No | 0 | 10 | null | null
CREATED_ON | DATE | No | sysdate | 11 | null | null
CREATED_BY | VARCHAR2(255 BYTE) | Yes | null | 12 | null | null
LAST_UPDATED_ON | DATE | Yes | null | 13 | null | null
LAST_UPDATED_BY | VARCHAR2(255 BYTE) | Yes | null | 14 | null | null