You can create temporal tables in two ways by using the
workbench.
Procedure
Use the Data Source Explorer or Administration Explorer
or view to create a new temporal table:
Locate the schema in which you want to create the temporal
table, then navigate to the Tables folder of
the schema.
Right-click the Tables folder,
then select Create. Choose a temporal table
type from the menu.
If you want to track data versioning
with a history table, create or specify a history table in the Versioning tab of the Properties view of the temporal table.
The temporal table is created in the database and schema
that you have selected.
Specify that an existing table is a temporal table.
Note: The table must be in alter mode before you can specify
that it is a temporal table.
Select the table that you want to specify as a temporal
table. The properties of the table display in the Properties view.
Open the Columns page and specify
the type of temporal table.
Note: To specify that a table
is a bitemporal table, select the System time period and Business time period options.
If you want to track data versioning
with a history table, create or specify a history table in the Versioning tab of the Properties view of the temporal table.