Skip to Main Content

Issue with creating a backup table

RajeshKotaJul 27 2018 — edited Jul 22 2019


I have a small query:

I have a primary table & i want to create a backup of that primary table in such a way that whenever a new record gets added to the primary, it should automatically add in the backup table & along with that if i delete any row in the primary table, the corresponding row should not get deleted from the backup table.

I need old records also in my backup table even though if i delete couple of rows in primary table.

Any help would be appreciated.

Thanks in advance.

This post has been answered by Frank Kulash on Jul 27 2018
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Aug 24 2018
Added on Jul 27 2018