Keywords and Identifiers

SQL statements are provided as strings to GemFire XD that must follow several rules.

Standard SQL Identifiers

Two categories of identifiers are defined in SQL-92 standard: ordinary and delimited.

The rules mentioned here for SQL identifiers apply to all names used in SQL statements including table-name, column-name, view-name, synonym-name, constraint-name, correlation-name, index-name, trigger-name, function-name and procedure-name. There are two categories of identifiers as defined in SQL-92 standard: ordinary and delimited. The ordinary names must follow the below mentioned rules:

Delimited identifiers are those enclosed within double quotation (") marks. If the identifier itself needs to have a double quotation mark then two consecutive double quotation marks should be used.

The following conventions are used in the syntax definitions in the remaining document: