System Tables

Information Schema
Range Table

Information Schema

The system tables in the schema INFORMATION_SCHEMA contain the meta data of all tables in the database as well as the current settings.

${item.topic}

${item.syntax}

Range Table

The range table is a dynamic system table that contains all values from a start to an end value. The table contains one column called X. Both the start and end values are included in the result. The table is used as follows:

Example:

SELECT X FROM SYSTEM_RANGE(1, 10);