var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: undelete deleted recrods from table
Is there way to undelete deleted records from a table? - For security reasons I need to delete records without removing them out of the database.
In other words: target is to design a procedure to delete records only logical.
I had the idea to use a field, saying record is deleted or not.
This field would control if data is hidden (logical deleted) or not. To undelete a record, only this field would change its state.
But it becomes difficult if you have many FK to logical deleted data.
Is there a better or easier way to do this?
Thanks for you help !!
How about moving them to a logically deleted table and then create a view?
The way we normally do this is to have a delete trigger on the table and insert the deleted record into another identical table.