Re: delete cascade
From: paul c <toledobythesea_at_oohay.ac>
Date: Sun, 22 Apr 2007 16:15:24 GMT
Message-ID: <wSLWh.114748$6m4.114417_at_pd7urf1no>
Date: Sun, 22 Apr 2007 16:15:24 GMT
Message-ID: <wSLWh.114748$6m4.114417_at_pd7urf1no>
Bob Badour wrote:
> ...
> Consider base relations you would likely find familiar with an Invoice
> relation, an InvoiceItem relation, and a foreign key reference from
> InvoiceItem to Invoice.
>
> In the first case, consider application views that essentially mirror
> the base relations. If someone tries to delete an invoice while invoice
> items remain, the dbms will balk with an error due to the foreign key
> constraint.
>
> In a second case, consider an application view that groups the invoice
> items as an RVA of each invoice. If one deletes an invoice, one deletes
> the invoice items at the same time and the dbms will not balk.
> ...
p Received on Sun Apr 22 2007 - 18:15:24 CEST