SYSHISTORYTABLES

The SYSHISTORYTABLES view contains one row for every history table, whether or not the history table is part of an established versioning relationship.

The following table describes the columns in the SYSHISTORYTABLES view:

Table 1. SYSHISTORYTABLES view
Column name	System Column Name	Data Type	Description
HISTORY_TABLE_SCHEMA	HSTDBNAME	VARCHAR(128)	Schema name of the history table.
HISTORY_TABLE_NAME	HSTTBNAME	VARCHAR(128)	Name of the history table.
VERSIONING_STATUS	VERSIONSTS	CHAR(1)	Status of versioning E A versioning relationship between the system-period temporal table and the history table has been established. The system-period temporal table is storing previous versions of modified rows in this history table. D A versioning relationship between this history table and the system-period temporal table has been defined but not established.
PERIOD_NAME	PERIODNAME	VARCHAR(128)	Name of the period.
TABLE_SCHEMA	DBNAME	VARCHAR(128) Nullable	Name of the SQL schema that contains the temporal table. Contains the null value if the system-period temporal table does not exist.
TABLE_NAME	TBNAME	VARCHAR(128) Nullable	Name of the temporal table. Contains the null value if the system-period temporal table does not exist.
SYSTEM_HISTORY_SCHEMA	SYSHSTLIB	CHAR(10)	System schema name of the history table.
SYSTEM_HISTORY_TABLE_NAME	SYSHSTNAME	CHAR(10)	System name of the history table.
SYSTEM_TABLE_SCHEMA	SYS_DNAME	CHAR(10) Nullable	System schema name of the temporal table. Contains the null value if the system-period temporal table does not exist.
SYSTEM_TABLE_NAME	SYS_TNAME	CHAR(10) Nullable	System name of the temporal table. Contains the null value if the system-period temporal table does not exist.