DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
Each row represents the definition of a period for use with a temporal table.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| PERIODNAME | VARCHAR (128) | Name of the period. | |
| TABSCHEMA | VARCHAR (128) | Schema name of the table. | |
| TABNAME | VARCHAR (128) | Unqualified name of the table. | |
| BEGINCOLNAME | VARCHAR (128) | Period begin column name. | |
| ENDCOLNAME | VARCHAR (128) | Period end column name. | |
| PERIODTYPE | CHAR (1) | Type of period.
|
|
| HISTORYTABSCHEMA | VARCHAR (128) | Schema name of the history table. | |
| HISTORYTABNAME | VARCHAR (128) | Unqualified name of the history table. |