|Item||Definition and Comments|
|Letter||An uppercase or lowercase alphabetic character ranging from A through Z.|
|Number||A digit ranging from 0 through 9.
Do not use commas when typing a number with more than 3 digits.
|Word||Keywords and variables.
|Spaces||Use one space between items such as keywords or variables.|
|Punctuation||Type all punctuation exactly as it appears in the diagram.|
The main path along the syntax diagram begins at the left with a keyword, and proceeds, left to right, to the vertical bar, which marks the end of the diagram. Paths that do not have an arrow or a vertical bar only show portions of the syntax.
The only part of a path that reads from right to left is a loop.
Paths that are too long for one line use continuation links. Continuation links are circled letters indicating the beginning and end of a link:
When you see a circled letter in a syntax diagram, go to the corresponding circled letter and continue reading.
Required entries appear on the main path:
If you can choose from more than one entry, the choices appear vertically, in a stack. The first entry appears on the main path:
You may choose to include or disregard optional entries. Optional entries appear below the main path:
If you can optionally choose from more than one entry, all the choices appear below the main path:
Some commands and statements treat one of the optional choices as a default value. This value is UNDERLINED. It is presumed to be selected if you type the command or statement without specifying one of the options.
String literals appear in apostrophes:
If a keyword or a reserved word has a valid abbreviation, the unabbreviated form always appears on the main path. The shortest valid abbreviation appears beneath.
- SHOW CONTROLS
- SHOW CONTROL
A loop is an entry or a group of entries that you can repeat one or more times. Syntax diagrams show loops as a return path above the main path, over the item or items that you can repeat:
Read loops from right to left.The following conventions apply to loops:
|maximum number of entries allowed||The number appears in a circle on the return path.||In the example, you may type cname a maximum of four times.|
|minimum number of entries allowed||The number appears in a square on the return path.||In the example, you must type at least three groups of column names.|
|separator character required between entries||The character appears on the return path.
If the diagram does not show a separator character, use one blank space.
|In the example, the separator character is a comma.|
|delimiter character required around entries||The beginning and end characters appear outside the return path.
Generally, a space is not needed between delimiter characters and entries.
|In the example, the delimiter characters are the left and right parentheses.|
Sometimes a piece of a syntax phrase is too large to fit into the diagram. Such a phrase is indicated by a break in the path, marked by (|) terminators on each side of the break. The name for the excerpted piece appears between the terminators in boldface type.
The boldface excerpt name and the excerpted phrase appears immediately after the main diagram. The excerpted phrase starts and ends with a plain horizontal line:
Multiple Legitimate Phrases
- DATABASE dbname
- TABLE tname
- VIEW vname