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.

