Netezza Performance Server SQL lexical structure
An SQL statement is a sequence of commands. Each command consists of a sequence of tokens that are terminated by an optional semicolon with the end of the input that terminates the command.
Tokens can be:
- Keywords
- Words with a fixed meaning in SQL.
- Identifiers
- Names of users, tables, columns, or other database objects.
- Constants
- Strings, integers, and floating-point numbers.
- Comments
- An arbitrary sequence of characters that begins with double dashes and extending to the end of the line.
- Constraints
- A rule that restricts the value for one or more columns in a table. Netezza Performance Server does not support constraint checking and referential integrity.