Reserved Keywords
Table 1 lists the keywords reserved by the system and whether they are reserved in other SQL standards. If you need to use these keywords as identifiers, add double quotation marks.
| Keyword | SQL:2016 | SQL-92 |
|---|---|---|
| ALTER | reserved | reserved |
| AND | reserved | reserved |
| AS | reserved | reserved |
| BETWEEN | reserved | reserved |
| BY | reserved | reserved |
| CASE | reserved | reserved |
| CAST | reserved | reserved |
| CONSTRAINT | reserved | reserved |
| CREATE | reserved | reserved |
| CROSS | reserved | reserved |
| CUBE | reserved | reserved |
| CURRENT_DATE | reserved | reserved |
| CURRENT_PATH | reserved | reserved |
| CURRENT_ROLE | reserved | reserved |
| CURRENT_TIME | reserved | reserved |
| CURRENT_TIMESTAMP | reserved | reserved |
| CURRENT_USER | reserved | reserved |
| DEALLOCATE | reserved | reserved |
| DELETE | reserved | reserved |
| DESCRIBE | reserved | reserved |
| DISTINCT | reserved | reserved |
| DROP | reserved | reserved |
| ELSE | reserved | reserved |
| END | reserved | reserved |
| ESCAPE | reserved | reserved |
| EXCEPT | reserved | reserved |
| EXECUTE | reserved | reserved |
| EXISTS | reserved | reserved |
| EXTRACT | reserved | reserved |
| FALSE | reserved | reserved |
| FOR | reserved | reserved |
| FROM | reserved | reserved |
| FULL | reserved | reserved |
| GROUP | reserved | reserved |
| GROUPING | reserved | reserved |
| HAVING | reserved | reserved |
| IN | reserved | reserved |
| INNER | reserved | reserved |
| INSERT | reserved | reserved |
| INTERSECT | reserved | reserved |
| INTO | reserved | reserved |
| IS | reserved | reserved |
| JOIN | reserved | reserved |
| LEFT | reserved | reserved |
| LIKE | reserved | reserved |
| LOCALTIME | reserved | reserved |
| LOCALTIMESTAMP | reserved | reserved |
| NATURAL | reserved | reserved |
| NORMALIZE | reserved | reserved |
| NOT | reserved | reserved |
| NULL | reserved | reserved |
| ON | reserved | reserved |
| OR | reserved | reserved |
| ORDER | reserved | reserved |
| OUTER | reserved | reserved |
| PREPARE | reserved | reserved |
| RECURSIVE | reserved | reserved |
| RIGHT | reserved | reserved |
| ROLLUP | reserved | reserved |
| SELECT | reserved | reserved |
| TABLE | reserved | reserved |
| THEN | reserved | reserved |
| TRUE | reserved | reserved |
| UESCAPE | reserved | reserved |
| UNION | reserved | reserved |
| UNNEST | reserved | reserved |
| USING | reserved | reserved |
| VALUES | reserved | reserved |
| WHEN | reserved | reserved |
| WHERE | reserved | reserved |
| WITH | reserved | reserved |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.