Syntax Notation

This documentation uses the BNF syntax notation with the following conventions:

Explanation

KEYWORDS

Keywords are shown in uppercase letters for the sake of clarity. They can be entered in uppercase or lowercase letters.

<xyz>

Terms in angle brackets are placeholders for syntactical units explained in this document. Do not use angle brackets when entering an SQL statement.

<!  Text  !>

Texts enclosed in angled brackets and exclamation points indicate that the syntactical unit is explained by means of a text. Do not use angled brackets and exclamation points when entering an SQL statement.

clause ::= rule

Clauses are the building blocks of SQL statements. Rules describe how these building blocks are put together to form more complex clauses and also dictate the notation that is used.

clause1 clause2

The two clauses are written one after the other, separated by at least one blank.

[clause]

Optional clause. This clause can be ignored. Do not use square brackets when entering an SQL statement.

Clause1 | clause2 | ... | clausen

Alternative clauses. You can use exactly one of these clauses.

Clause,...

The clause can be repeated as often as required. The individual repetitions must be written one after the other and separated by a comma and any number of blanks.

Clause ...

The clause can be repeated as often as required. The individual repetitions must be written one after the other and separated by spaces.

Clause...

The clause can be repeated as often as required. The individual repetitions are to be recorded in direct sequence.

See also:

Syntax List

Syntax Changes

Glossary, Syntax Notation