Question

怎样删除Oracle中有主键约束还有外键约束的table

Answer 1

oracle 有功能把所有主外键都去掉,这时候你随便删除
删除完在加上就OK拉
这个简单吧

Answer 2

select a.constraint_name 外键名, a.table_name 外键表, b.constraint_name 主键名, b.table_name 关联主键表
from user_constraints a, user_constraints b
where b.table_name='PRODUCT' and a.constraint_type = 'R' and b.constraint_type = 'P' and a.r_constraint_name = b.constraint_name

Answer 3

请查阅官方文档之Alter table句法

Answer 4

delete from table1;
commit ;
delete from table2;
commit;
....