oracle清空所有表数据

数据库  /  管理员 发布于 6年前   174

方法：

1. 删除所有外键约束

2. drop表

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

/*==============================================================*/ /* DBMS name:   ORACLE Version 10g  */ /* Created on:   2013/8/16 14:30:03  */ /*==============================================================*/   alter table Da_pic   drop constraint FK_DA_PIC_REFERENCE_DA_PICSU;  drop table Da_pic cascade constraints;  drop table Da_picsubject cascade constraints;  /*==============================================================*/ /* Table: Da_pic*/ /*==============================================================*/ create table Da_pic (   ID          VARCHAR2(200)          not null,   no          VARCHAR2(200),   subjiectid      VARCHAR2(200),   Name         VARCHAR2(400),   UploadTime      DATE,   UserId        VARCHAR2(200),   picdate       DATE,   place        VARCHAR2(200),   people        VARCHAR2(200),   event        VARCHAR2(200),   background      VARCHAR2(200),   cameramen      VARCHAR2(200),   serial        INTEGER,   IsEffect       VARCHAR2(200),   constraint PK_DA_PIC primary key (ID) );  /*==============================================================*/ /* Table: Da_picsubject         */ /*==============================================================*/ create table Da_picsubject (   ID          VARCHAR2(200)          not null,   no          VARCHAR2(200),   title        VARCHAR2(200),   year         VARCHAR2(200),   type         VARCHAR2(200),   gdtime        DATE,   iseffect       VARCHAR2(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);