Reserved Keywords
- Last Updated: October 5, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The following words are reserved for use in SQL statements. If they are used for file or column names in a database that you use, you must enclose them in double (") quotation marks in any SQL statement where they appear as file or column names.
| ALL | FROM | LIKE | OR |
| AND | FULL | NATURAL | ORDER |
| BETWEEN | GROUP | NOT | RIGHT |
| COMPUTE | HAVING | NULL | UNION |
| CROSS | INNER | ON | WHERE |
| DISTINCT | INTO | OPTIONS | |
| FOR | LEFT | OR |