Re: SQL statement for Deleting

change the foreign key to:

where foreign key (login) references users (login) on delete cascade;

Rick

In article <31F800A3.3BDD_at_evitech.evitech.fi>, Mikko Rusama <mikkohr_at_evitech.evitech.fi> writes:

>I have created two databases USERS and ORDER:
>
>USERS have the following tables:
>login , primary key
>fullname
>num
>
>and the ORDER has:
>login
>orderno
>where foreign key(login) references users
>
>So ORDER is dependent on the USERS database
>When I try to delete from the USERS database user which exists also in
>the HOBBBY, error message : ORA-02292: integrity constraint violated -
>child record found.
>
>So I have to delete that particular user from the HOBBY database in
>order to delete it from the USERS database.
>
>Is there SQL statement that also deletes particular user from all the
>child databases.
>
>Thanks for help!
>
>
Received on Sun Jul 28 1996 - 00:00:00 CEST