Chapter 5. Temporal data management and analytics in an operational warehouse 187
created using either the Design Studio tooling or by using SQL that was coded
manually.
The history table is to have all of the same columns as the main table so that it
can track all changes without losing any history or previous values.
Creating history tables with Design Studio
If the system-period temporal table has been created using Design Studio as
discussed in “Using the Design Studio tooling” on page 184, then the history
table is created automatically at the same time. The exact same column
definitions are used in the history table as the base table.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.