Ok, I'm very new to triggers so please excuse my ignorance.
I want the following to happen:
- user deletes row from a database
- row gets inserted into a backup table
Is this possible with a Delete trigger?
Basically a client wants rows to be saved in another table when they delete (so they can possibly retrieve them). Be more careful with their deleting I say!
Thanks for any help.
I want the following to happen:
- user deletes row from a database
- row gets inserted into a backup table
Is this possible with a Delete trigger?
Basically a client wants rows to be saved in another table when they delete (so they can possibly retrieve them). Be more careful with their deleting I say!
Thanks for any help.