制約

●制約検索（C：CHECK、P：PRIMARYKEY、U：UNIQUE）
SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, OWNER, STATUS
FROM USER_CONSTRAINTS
WHERE TABLE_NAME = '&TABLE_NAME';

●制約カラム検索
SELECT *
FROM USER_CONS_COLUMNS
WHERE CONSTRAINT_NAME = '&CONSTRAINT_NAME';