General DDL Syntax Rules

Keywords

  • Keywords must be written all-uppercase, all-lowercase, or capitalized; for example KEYWORD, keyword, and Keyword are all valid notations for the same keyword, but keyWord and KeyWord will cause a syntax error.

Identifiers

  • Identifiers are case-insignificant; for example, if two view entities are named myView and MYVIEW, respectively, there will be a naming conflict.
  • The maximum length of identifiers is 30 characters.

Literals

  • Only single quotes are allowed for string literals.
  • Numbers cannot be abbreviated; for example .5 is not allowed for 0.5.

Comments

  • Double slashes ('//') start a comment from the token to the end of the line.
  • '/*' and '*/' delimit multi-line and inline comments.

Delimiters

  • Statements may be terminated with a semi-colon ';' .