oracle清空所有表数据

来源：互联网发布：北京考研机构知乎编辑：程序博客网时间：2024/04/26 08:49

方法：

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);