쿼리로 제약조건 확인하기

SELECT * FROM USER_CONSTRAINTS
 WHERE CONSTRAINT_NAME = 'SYS_C0065558'

-- CONSTRAINT_TYPE P:기본키, R:외래키, C:체크, UK-유니크


참조 : http://suite.tistory.com/entry/oracle-PRIMARY-KEY-FOREIGN-KEY-%EA%B8%B0%EB%B3%B8%ED%82%A4-%EC%99%B8%EB%9E%98%ED%82%A4-%EB%B3%B4%EA%B8%B0-sqlplus-%EB%A1%9C