Information Schema PERIODS Table
MariaDB starting with 11.4.1
The Information Schema PERIODS table provides information about Application-Time Periods.
It contains the following columns:
| Column | Description |
|---|---|
| TABLE_CATALOG | Always contains the string 'def'. |
| TABLE_SCHEMA | Database name. |
| TABLE_NAME | Table name. |
| PERIOD | Period name. |
| START_COLUMN_NAME | Name of the column that starts the period. |
| END_COLUMN_NAME | Name of the column that ends the period. |
Example
CREATE OR REPLACE TABLE t1( name VARCHAR(50), date_1 DATE, date_2 DATE, PERIOD FOR date_period(date_1, date_2) ); SELECT * FROM INFORMATION_SCHEMA.PERIODS; +---------------+--------------+------------+-------------+-------------------+-----------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PERIOD | START_COLUMN_NAME | END_COLUMN_NAME | +---------------+--------------+------------+-------------+-------------------+-----------------+ | def | test | t1 | date_period | date_1 | date_2 | +---------------+--------------+------------+-------------+-------------------+-----------------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
