So, I am discovering this article after 10 years. It was still immensely helpful.
I've modified SQLBuddy123's query somewhat to include info about Change Data Capture (for you fans of Oracle...
- This reply was modified 4 years, 10 months ago by Chris. Reason: more info found