使用这个命令drop table Depot不成功,提示:drop table Depot
*第 1 行出现错误:
ORA-02449: 表中的唯一/主键被外键引用
*第 1 行出现错误:
ORA-02449: 表中的唯一/主键被外键引用
解决方案 »
- TRS5.2、Lucene3.1、oracle11.2g的全文、天宇的全文索引功能比较
- oracle10类似SQL2000编辑表的功能,在线等
- 紧急求救,在线等……oracle表复制问题
- 关于访问oracle数据库数据是乱码的问题
- Oracle 10g 如何查看 DML_LOCKS 参数值?
- 如何将几个schema下的对象的查询权限赋予一个user,谢谢
- 如何在SQL PULS里面输出这样的表格形式呢?
- 请问Oracle里的自动增加字段是哪个?
- oracle 表加锁问题
- 急!!在线等!!oracle 存储过程加入对工资求最大值,最小值,平均值,总值
- 我的表空间中有个dblink,每次导入时,就出现连接的视图无法编译,能不能忽略错误,让对象建立完毕呢?
- 求一个sql语句
--可以通过如下查询,得到表中都有哪些约束,然后斟酌处理
SELECT constraint_name, table_name, r_owner, r_constraint_name
FROM all_constraints
WHERE table_name = 'tableName'and owner = 'owner'
(dno varchar2(5),
dname varchar2(20),
daddress varchar2(20),
constraint pk_dno primary key(dno) );
Create table BusType
(tno varchar2(5),
tdescript varchar2(20),
constraint pk_tno primary key(tno) );
Create table BusDriver
(bdno varchar2(5),
bdname varchar2(20),
bdsalary number(6,2),
pcvdate date,
dno varchar2(5),
constraint pk_bdno primary key(bdno),
constraint fk_dno foreign key(dno) references Depot(dno) );
Create table Cleaner
(cno varchar2(5),
cname varchar2(20),
csalary number(6,2),
dno varchar2(5),
constraint pk_cno primary key(cno),
constraint fk_dno1 foreign key(dno) references Depot(dno) );
Create table Route
(rno varchar2(5),
rdescript varchar2(30),
dno varchar2(5),
constraint pk_rno primary key(rno),
constraint fk_dno2 foreign key(dno) references Depot(dno) );
Create table Bus
(reg_no varchar2(10),
model varchar2(20),
tno varchar2(5),
dno varchar2(5),
cno varchar2(5),
constraint pk_reg_no primary key(reg_no),
constraint fk_tno foreign key(tno) references BusType(tno),
constraint fk_dno3 foreign key(dno) references Depot(dno),
constraint fk_cno foreign key(cno) references Cleaner(cno));
Create table Ability
(bdno varchar2(5),
rno varchar2(5),
constraint pk_drroute primary key(bdno, rno),
constraint fk_bdno foreign key(bdno) references busdriver(bdno),
constraint fk_rno foreign key(rno) references route(rno) );Create table Training
(bdno varchar2(5),
tno varchar2(5),
trainingdate date,
constraint pk_drbustype primary key(bdno, tno),
constraint fk_bdno2 foreign key(bdno) references busdriver(bdno),
constraint fk_tno2 foreign key(tno) references BusType(tno));Create table Restriction
(rno varchar2(5),
tno varchar2(5),
constraint pk_rbustype primary key(rno, tno),
constraint fk_rno2 foreign key(rno) references route(rno),
constraint fk_tno3 foreign key(tno) references BusType(tno));表都在这,该删哪个??
删除主表的时候会把子表的相关记录全部删除掉
alter table busdriver drop constraint fk_dno;alter table cleaner drop constraint fk_dno1;alter table route drop constraint fk_dno2;alter table bus drop constraint fk_dno3;