2 Nov
2017
2 Nov
'17
6:18 a.m.
Totally agree - my default would be an 'instead of Delete' trigger that set a deleted flag (and logged it), and all regular user views to filter on that flag.
On 02-Nov-2017 3:31 AM, Ted Roche wrote:
DELETE is one of the easist ways to screw up a database that doesn't have proper RI declared. Clients all the time ask to "delete" Customer X because they no longer work with them, business closed, got bought, or something.
<snip>