oracle清空所有表数据

方法：

1. 删除所有外键约束

2. drop表

3. 添加外键约束
代码使用powerdesign生成

 
 
 
 
 
 
alter table Da_pic 
  drop constraint FK_DA_PIC_REFERENCE_DA_PICSU; 
 
drop table Da_pic cascade constraints; 
 
drop table Da_picsubject cascade constraints; 
 
 
 
 
create table Da_pic ( 
  ID   VARCHAr2(200)   not null, 
  no   VARCHAr2(200), 
  subjiectid      VARCHAr2(200), 
  Name  VARCHAr2(400), 
  UploadTime      DATE, 
  UserId VARCHAr2(200), 
  picdateDATE, 
  place VARCHAr2(200), 
  people VARCHAr2(200), 
  event VARCHAr2(200), 
  background      VARCHAr2(200), 
  cameramen      VARCHAr2(200), 
  serial INTEGER, 
  IsEffectVARCHAr2(200), 
  constraint PK_DA_PIC primary key (ID) 
); 
 
 
 
 
create table Da_picsubject ( 
  ID   VARCHAr2(200)   not null, 
  no   VARCHAr2(200), 
  title VARCHAr2(200), 
  year  VARCHAr2(200), 
  type  VARCHAr2(200), 
  gdtime DATE, 
  iseffectVARCHAr2(200), 
  seiral INTEGER, 
  constraint PK_DA_PICSUBJECT primary key (ID) 
); 
 
alter table Da_pic 
  add constraint FK_DA_PIC_REFERENCE_DA_PICSU foreign key (subjiectid) 
   references Da_picsubject (ID);