Table clone on same database.
-
Dear CPians, I need to keep a mirror table of an existing table within the same database. I need my clone to reflect to the original one. I need to have all inserts and updates but NO deletes! Has anyone got any ideas of how should I do that? Thanking you in advance.
Excellence is not an act, but a habit!
Aristotle
-
Dear CPians, I need to keep a mirror table of an existing table within the same database. I need my clone to reflect to the original one. I need to have all inserts and updates but NO deletes! Has anyone got any ideas of how should I do that? Thanking you in advance.
Excellence is not an act, but a habit!
Aristotle
Triggers on the source table to copy the changes to the mirrored table.
Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog