Syntax Conventions

Key

BIGCaps means it's a keyword (command).
MIXedCaps mixed with lowercase letters means it's a keyword and you can type either the full word or just the part in caps.
littleLowercase words are variables; supply your own.
{ }Curly braces mean you must choose at least one of the enclosed options.
[ ]Brackets mean choosing one or more of the enclosed options is optional.
( )Parentheses are actually typed as part of the command (unlike curly braces and brackets, which are syntax symbols).
|The vertical bar means you choose a maximum of one option.
,The comma means you choose as many options as you like and separate your choices with commas that you type as part of the command.
. . .The ellipses mean you can do it again, whatever it was. ...

Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.