SQL> SELECT SUBSTR(A.COLUMN_NAME,1,15) COLUMN_NAME, DECODE(B.CONSTRAINT_TYPE, 'P','PRIMARY KEY', 'U','UNIQUE KEY', 'C','CHECK OR NOT NULL', 'R','FOREIGN KEY') CONSTRAINT_TYPE, A.CONSTRAINT_NAME FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B WHERE A.TABLE_NAME = UPPER('&table_name') AND A.TABLE_NAME = B.TABLE_NAME AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME ORDER BY 1; -- 테이블 명을 입력 하면 됩니다.table_name의 값을 입력하십시오: emp2 COLUMN_NAME CONSTRAINT_TYPE CONSTRAINT_NAME------------------- ----------------- --------------DEPTNO CHECK OR NOT NULL SYS_C001362 FOREIGN KEY EMP2_FK_DEPTNOEMPNO PRIMARY KEY EMP2_PK_EMPNOENAME CHECK OR NOT NULL EMP2_NN_ENAMEMGR UNIQUE KEY EMP2_UP_MGR