Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
delete-cascade
0 views
Skip to first unread message
claudio
Oct 13, 2000, 3:00:00 AM10/13/00
to
I have difficulties in deleting a row from a table with a primary key
connected with constraints (foreign keys) to other tables because an error
messages compares.
I want delete all the rows connected to this row but i don't want eliminate
the constraints about the check of inserted dates.
Have you the answer? Thank you
connected with constraints (foreign keys) to other tables because an error
messages compares.
I want delete all the rows connected to this row but i don't want eliminate
the constraints about the check of inserted dates.
Have you the answer? Thank you
Jesse "the body" Ventura
Oct 13, 2000, 3:00:00 AM10/13/00
to
Yea, you have to delete from the tables in the reverse order that the
constraints force you to insert.
constraints force you to insert.
For example, if you have an ORDERS table and an ORDERSDETAIL table with a
foreign key constraint on ORDERSDETAIL you have to delete from ORDERSDETAIL
every record that is constrained before you delete the record from the
ORDERS table.
"claudio" <man...@tin.it> wrote in message
news:8s70uq$jl2$1...@nslave3.tin.it...
0 new messages