My earlier question was asking: When does the data in a cascading table get deleted when there are several other records pointing to the same cascading record?
As an example - Three people (three records) in PersonT each refer to the same address data located within table AddressT. There exists a global relationship between these two tables using Foreign Key AddressID in the PersonT table and the Primary Key (AddressID) in the AddressT table. In each of the PersonT records, they each refer to the same address record with AddressT.
Will the AddressT record remain in the AddressT table until all three records have been deleted from PersonT?
(as a side note - yes I could try this; but I was asking so that others could also get an answer to this question)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.