another question--怎么delete a row from a table# Database - 数据库
w*g
1 楼
other talbes have foreign key referrence to some attribute of this table. So if
I just use delete from...,I will get a msg like this:
ORA-02292: integrity constraint (WGUAN.SYS_C0061954) violated - child
record found
I tried to drop the foreign key in those tables using:
DROP FOREIGN KEY (***) REFENERRENCES tablename (**)
error msg:
ORA-00905: missing keyword
What should I do? Thanks.
I just use delete from...,I will get a msg like this:
ORA-02292: integrity constraint (WGUAN.SYS_C0061954) violated - child
record found
I tried to drop the foreign key in those tables using:
DROP FOREIGN KEY (***) REFENERRENCES tablename (**)
error msg:
ORA-00905: missing keyword
What should I do? Thanks.
