The Tairus Blog

I have been very busy with work lately and I had put my blogging career on hold, I am back now.. For this article I will try to be very precise two simple steps. STEP ONE Have a similar table as the table you are listening in for delete actions. On your new backup table you might want to have more fields like the delete_user, the computer_name where this was done and the time_stamp. You can easily create the backup table by copying the existing table then adding the extra columns. There are many ways to do this so i will let you decide on which one you prefer but I would normally quickly do it as follows; Run the following sql Create table mytablename_after_delete as select * from mytable; --then  empty the table TRUNCATE TABLE mytablename_after_delete; --the add your extra columns using alter command alter table mytablename_after_delete add sysdate timestamp; --you can make it varchar if need be alter table mytablename_after_delete add deleted_by varchar(30); --a...