Question

oracle中有主外键关系的两张表如何同时删除？

表结构如下：
Create Table A001(id number (4) Not Null Primary Key,name varchar2(20));
Create Table A002(id number (4) references A001(id)on delete cascade, age number(2,0));
不用触发器、存储过程，只用SQL命令。

Answer 1

用drop指令，先drop有foreign key的，再drop有primary key 的。

Drop A002;
Drop A001;

即可！

Answer 2

delete from A002;
commit ;
delete from A001;
commit;

Answer 3

alter table A002 disable constraint 外键名称;
drop table A001;drop table A002

Answer 4

drop table a001 cascade constraints;

drop table a002;