CONSTRAINT 정보 조회

--select * from user_constraints; -- constraint걸린항목 찾기

ALTER TABLE TABEL_NAME
DROP (CONSTRAINT_NAME) CASECADE CONSTRAINTS; -- CONSTRAINT 삭제

select *
from user_constraints
wHERE owner = 'OWNER_NAME'
AND TABLE_NAME = 'TABLE_NAME'
AND CONSTRAINT_TYPE IN ('C','R','P') ; -- C - CHILD, R - 외래키, P-PK