oracle清空所有表数据

前端之家收集整理的这篇文章主要介绍了oracle清空所有表数据前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

方法

1. 删除所有外键约束

2. drop表

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

sql;"> /*==============================================================*/ /* 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,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);

原文链接:https://www.f2er.com/oracle/65316.html

猜你在找的Oracle相关文章