[ORACLE] PK, UK table 조회

-- PK, UK table list set line 300 col OWNER for a20 col TABLE_NAME for a30 col COLUMN_NAME for a30 SELECT A.OWNER, A.TABLE_NAME, A.COLUMN_NAME FROM USER_CONS_COLUMNS A INNER JOIN USER_CONSTRAINTS B ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME WHERE (B.CONSTRAINT_TYPE = 'P' or B.CONSTRAINT_TYPE = 'U') and COLUMN_NAME like '%%' ;