1 Attachment(s)
How to avoid deleting a database record:
With the diagram shown below it is clear that I cannot delete any records for the tables connected to the center one because of foreign key constrains.
I could however delete any records found in the main table “Listing”.
What functions or properties can I give to this table “Listing” so NO records can ever be deleted?
Thanks
Re: How to avoid deleting a database record:
Is this MS SQL SERVER??
Look into INSTEAD of TRIGGERS - and simply stop the DELETE with that.
I don't have SQL here to play with or I would whip one up for you...