The following conventions are used in the SQL syntax descriptions:
Keywords All SQL keywords are shown in UPPER CASE. However, SQL keywords are case insensitive, so you can enter keywords in any case you wish; SELECT is the same as Select which is the same as select.
Placeholders Items that must be replaced with appropriate identifiers or expressions are shown in italics.
Continuation Lines beginning with an ellipsis (...) are a continuation from the previous line.
Optional portions Optional portions of a statement are enclosed by square brackets. For example,
RELEASE SAVEPOINT [ savepoint-name ]
indicates that the savepoint-name is optional. The square brackets should not be typed.
Repeating items Lists of repeating items are shown with an element of the list followed by an ellipsis (three dots). One or more list elements are allowed. When more than one is specified, they must be separated by commas if indicated as such. For example,
UNIQUE (column-name [, ...])
indicates that you can specify column-name more than once separated by commas. The square brackets should not be typed.
