SYSPERIODS

The SYSPERIODS view contains one row for every period defined for a temporal table in an SQL schema.

The following table describes the columns in the SYSPERIODS view:

Table 1. SYSPERIODS view
Column name	System Column Name	Data Type	Description
PERIOD_NAME	PERIODNAME	VARCHAR(128)	Name of the period.
TABLE_SCHEMA	DBNAME	VARCHAR(128)	Name of the SQL schema that contains the table.
TABLE_NAME	TBNAME	VARCHAR(128)	Name of the temporal table.
BEGIN_COLUMN_NAME	BGNCOLNAME	VARCHAR(128)	Period begin column name.
END_COLUMN_NAME	ENDCOLNAME	VARCHAR(128)	Period end column name
PERIOD_TYPE	PERIODTYPE	CHAR(1)	The type of period for this row: S System period
HISTORY_TABLE_SCHEMA	HSTDBNAME	VARCHAR(128) Nullable	Schema name of the history table. Contains the null value if versioning has not been added to the system-period temporal table.
HISTORY_TABLE_NAME	HSTTBNAME	VARCHAR(128) Nullable	Name of the history table. Contains the null value if versioning has not been added to the system-period temporal table.
ON_DELETE_ADD_EXTRA_ROW	ADD_ROW	VARCHAR(3) Nullable	Versioning defined with ON DELETE ADD EXTRA ROW. YES ON DELETE ADD EXTRA ROW was specified. NO ON DELETE ADD EXTRA ROW was not specified. Contains the null value if versioning has not been added to the system-period temporal table.
VERSIONING_STATUS	VERSIONSTS	CHAR(1) Nullable	Status of versioning E A versioning relationship between the system-period temporal table and the history table has been established. The history table is being used to store previous versions of the system-period temporal table's modified rows. D A versioning relationship between the system-period temporal table and the history table has been defined but not established. Operations on the system-period temporal table will be prevented until the versioning relationship is established or versioning of the system-period temporal table is removed. Contains the null value if versioning has not been added to the system-period temporal table.
SYSTEM_TABLE_SCHEMA	SYS_DNAME	CHAR(10)	System schema name of temporal table.
SYSTEM_TABLE_NAME	SYS_TNAME	CHAR(10)	System name of temporal table.
SYSTEM_HISTORY_TABLE_SCHEMA	SYSHSTLIB	CHAR(10) Nullable	System schema name of the history table. Contains the null value if versioning has not been added to the system-period temporal table.
SYSTEM_HISTORY_TABLE_NAME	SYSHSTNAME	CHAR(10) Nullable	System name of the history table. Contains the null value if versioning has not been added to the system-period temporal table.
SYSTEM_BEGIN_COLUMN_NAME	SYSBGNCOL	CHAR(10)	Period begin system column name.
SYSTEM_END_COLUMN_NAME	SYSENDCOL	CHAR(10)	Period end system column name