| 컬럼 이름 | 설명 |
| owner | 제한 조건을 생성한 사용자의 ID |
| constraint_name | 생성된 제한조건의 이름 |
| table_name | 생성된 제한 조건이 적용된 테이블 이름 |
| column_name | 생성된 제한 조건이 적용된 테이블의 컬럼 이름 |
【예제】
SQL> select count(*) from dba_cons_columns;
COUNT(*)
----------
1353
SQL> desc dba_constraints;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
CONSTRAINT_TYPE VARCHAR2(1)
TABLE_NAME NOT NULL VARCHAR2(30)
SEARCH_CONDITION LONG
R_OWNER VARCHAR2(30)
R_CONSTRAINT_NAME VARCHAR2(30)
DELETE_RULE VARCHAR2(9)
STATUS VARCHAR2(8)
DEFERRABLE VARCHAR2(14)
DEFERRED VARCHAR2(9)
VALIDATED VARCHAR2(13)
GENERATED VARCHAR2(14)
BAD VARCHAR2(3)
RELY VARCHAR2(4)
LAST_CHANGE DATE
INDEX_OWNER VARCHAR2(30)
INDEX_NAME VARCHAR2(30)
INVALID VARCHAR2(7)
VIEW_RELATED VARCHAR2(14)
SQL> desc dba_cons_columns;
Name Null? Type
----------------------------------------- -------- ----------------------------
OWNER NOT NULL VARCHAR2(30)
CONSTRAINT_NAME NOT NULL VARCHAR2(30)
TABLE_NAME NOT NULL VARCHAR2(30)
COLUMN_NAME VARCHAR2(4000)
POSITION NUMBER
SQL> select b.constraint_name AS "PK", a.constraint_name AS "FK"
2 FROM dba_constraints a, dba_cons_columns b
3 WHERE a.owner='JIJOE' AND a.table_name='TABLE2'
4 AND a.r_owner=b.owner AND a.r_constraint_name=b.constraint_name
5 AND a.constraint_type='R';
PK FK
------------------------------ ------------------------------
TABLE1_NO_PK TABLE2_NO_FK
SQL> list
1 select a.constraint_name, a.status, b.column_name
2 FROM dba_constraints a, dba_cons_columns b
3* WHERE a.owner=b.owner AND a.table_name='TABLE1'
SQL> /
CONSTRAINT_NAME STATUS COLUMN_NAME
------------------------------ -------- --------------------
TABLE1_NO_PK ENABLED NO
TABLE1_MAIL_UK ENABLED NO
TABLE1_NAME_NN ENABLED NO
TABLE1_NO_PK ENABLED NAME
TABLE1_MAIL_UK ENABLED NAME
TABLE1_NAME_NN ENABLED NAME
TABLE1_NO_PK ENABLED MAIL
TABLE1_MAIL_UK ENABLED MAIL
TABLE1_NAME_NN ENABLED MAIL
TABLE1_NO_PK ENABLED NO
TABLE1_MAIL_UK ENABLED NO
CONSTRAINT_NAME STATUS COLUMN_NAME
------------------------------ -------- --------------------
TABLE1_NAME_NN ENABLED NO
TABLE1_NO_PK ENABLED JUMIN1
TABLE1_MAIL_UK ENABLED JUMIN1
TABLE1_NAME_NN ENABLED JUMIN1
TABLE1_NO_PK ENABLED JUMIN2
TABLE1_MAIL_UK ENABLED JUMIN2
TABLE1_NAME_NN ENABLED JUMIN2
TABLE1_NO_PK ENABLED ADDRESS
TABLE1_MAIL_UK ENABLED ADDRESS
TABLE1_NAME_NN ENABLED ADDRESS
TABLE1_NO_PK ENABLED ID
CONSTRAINT_NAME STATUS COLUMN_NAME
------------------------------ -------- --------------------
TABLE1_MAIL_UK ENABLED ID
TABLE1_NAME_NN ENABLED ID
TABLE1_NO_PK ENABLED ID
TABLE1_MAIL_UK ENABLED ID
TABLE1_NAME_NN ENABLED ID
TABLE1_NO_PK ENABLED NAME
TABLE1_MAIL_UK ENABLED NAME
TABLE1_NAME_NN ENABLED NAME
TABLE1_NO_PK ENABLED AA
TABLE1_MAIL_UK ENABLED AA
TABLE1_NAME_NN ENABLED AA
33 rows selected.
SQL>