Oracle sql developer 删表时遇到问题unique/primary keys in table referenced by foreign keys

来源 https://blog.csdn.net/u013736803/article/details/104631299/

1.禁用该约束

select * from user_constraints c where c.table_name='TABLE_NAME';
alter table TABLE_NAME disable constraint CONSTRAINT_NAME CASCADE;

 

2.删除表的时候，级联删除约束

drop table TABLE_NAME cascade constraints;