SQL Grammar

Index

Commands (Data Manipulation)

${item.topic}

Commands (Data Definition)

${item.topic}

Commands (Other)

${item.topic}

Datetime fields

${item.topic}

Other Grammar

${item.topic}

System Tables

Information Schema
Range Table

Details

Click on the header to switch between railroad diagram and BNF.

Commands (Data Manipulation)

${item.topic}

${item.syntax}

${item.railroad}

${item.text}

Example:

${item.example}

Commands (Data Definition)

${item.topic}

${item.syntax}

${item.railroad}

${item.text}

Example:

${item.example}

Commands (Other)

${item.topic}

${item.syntax}

${item.railroad}

${item.text}

Example:

${item.example}

Datetime fields

${item.topic}

${item.syntax}

${item.railroad}

${item.text}

Example:

${item.example}

Other Grammar

${item.topic}

${item.railroad}

${item.text}

Example:

${item.example}

System Tables

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.

Table	Columns
${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);