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;

 

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

上一篇:[C#参考]细说进程、应用程序域与上下文之间的关系


下一篇:C# 生成UPC-A码