Temporal syntax for ALTER TABLE allows you to create ANSI temporal system-time tables from existing tables.
Adding system-time to the table involves these ALTER TABLE operations:
- Adding a SYSTEM_TIME derived period column to the table by specifying the columns that will serve as the beginning and ending bounds of the system-time period.
- Adding or altering the columns that will serve as the beginning bound and ending bound of the system-time period. If these columns already exist in the table, special attributes must be added to them.
- Adding system versioning to the table.