oracle清空所有表数据

最新推荐文章于 2023-03-22 09:29:57 发布

metecyu

最新推荐文章于 2023-03-22 09:29:57 发布

阅读量1.5k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/metecyu/article/details/10001953

版权

数据库专栏收录该内容

12 篇文章 0 订阅

订阅专栏

方法：

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