Obsidian/Recognition/Programing/Tibero/제약조건 삭제.md

constraint

SELECT 'ALTER TABLE '||owner||'.'||table_name || ' DROP CONSTRAINT '||constraint_name ||' CASCADE;'
FROM ALL_CONSTRAINTS 
WHERE owner <> 'SYS'
AND con_type = 'REFERENTIAL'