SQL Grammar

Commands (Data Manipulation)

${item.topic}

Commands (Data Definition)

${item.topic}

Commands (Other)

${item.topic}

Other Grammar

${item.topic}

System Tables

Information Schema
Range Table

${item.topic}

${item.syntax}

${item.text}

Example:
${item.example}

${item.topic}

${item.syntax}

${item.text}

Example:
${item.example}

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.

TableColumns
${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: 

SELECT X FROM SYSTEM_RANGE(1, 10);