Finding the name of a history table

A history table is a base table that is associated with a system-period temporal table. A history table is used by Db2 to store the historical versions of the rows from the associated system-period temporal table.

About this task

If you know the name of the system-period temporal table, you can find the name of the corresponding history table.

Procedure

Begin general-use programming interface information. To find the name of a history table:

Issue a SELECT statement, such as:

SELECT VERSIONING_SCHEMA, VERSIONING_TABLE FROM SYSIBM.SYSTABLES WHERE
NAME = 'table-name' AND CREATOR = 'creator-name'

End general-use programming interface information.