SQL Syntax Reference

The following convention is used:

• [] = Optional
• | = Separates alternatives to choose from
• Enclosed in [ ] then optional to choose from these alternatives
• Enclosed in { } then must choose one alternative
• … = term preceding … may be repeated
• n = integer
• ‘string’ = string value
• synonyms
• CHARACTER SET = CHARSET = charset
• SCHEMA = DATABASE & SCHEMAS = DATABASES