|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.
When you see a circled letter in a syntax diagram, go to the corresponding circled letter and continue reading.
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.
- SHOW CONTROLS
- SHOW CONTROL
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.
Multiple Legitimate Phrases
- DATABASE dbname
- TABLE tname
- VIEW vname