预留关键字
表1罗列了系统预留的关键字,以及它们在其他SQL标准中是否为预留关键字。如果需要使用这些关键字作为标识符,请加注双引号。
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 |