附录五 系统保留字

更新时间:2017-11-02 12:15:58

DDL建库、建表对象保留字

数据库、表组、索引不能包含:

  1. DEBUG,WARN,ERROR,__

数据库、表组、表、列名均不能等于:

保留字
BEFORE reserved
BINARY reserved
BLOB reserved
BOTH reserved
CALL reserved
CASCADE reserved
CHANGE reserved
CHAR reserved
CHARACTER reserved
CHECK reserved
COLLATE reserved
CONDITION reserved
CONNECTION reserved
CONSTRAINT reserved
CONTINUE reserved
CONVERT reserved
CROSS reserved
CURRENT_DATE reserved
CURRENT_TIME reserved
CURRENT_TIMESTAMP reserved
CURRENT_USER reserved
CURSOR reserved
DATABASES reserved
STATUS reserved
DAY_HOUR reserved
DAY_MICROSECOND reserved
DAY_MINUTE reserved
DAY_SECOND reserved
DEC reserved
DECIMAL reserved
DECLARE reserved
DEFAULT reserved
DELAYED reserved
DETERMINISTIC reserved
DISTINCTROW reserved
DIV reserved
DOUBLE reserved
DUAL reserved
EACH reserved
ELSEIF reserved
ENCLOSED reserved
ESCAPED reserved
EXIT reserved
FETCH reserved
FLOAT reserved
FOR reserved
FORCE reserved
FOREIGN reserved
FUNCTION reserved
GOTO reserved
HOUR_MICROSECOND reserved
HOUR_MINUTE reserved
HOUR_SECOND reserved
IF reserved
INFILE reserved
INT reserved
INTEGER reserved
ITERATE reserved
KILL reserved
LABEL reserved
LEADING reserved
LEAVE reserved
LOAD reserved
LOCALTIME reserved
LOCALTIMESTAMP reserved
LOCK reserved
LONG reserved
LOOP reserved
MATCH reserved
MINUTE_MICROSECOND reserved
MINUTE_SECOND reserved
MOD reserved
MODIFIES reserved
OPTIMIZE reserved
OPTION reserved
OUT reserved
OUTFILE reserved
PRECISION reserved
RANGE reserved
READ reserved
REAL reserved
REFERENCES reserved
REGEXP reserved
RELEASE reserved
RENAME reserved
REPEAT reserved
REQUIRE reserved
RESTRICT reserved
RETURN reserved
RLIKE reserved
SCHEMA reserved
SECOND+MICROSECOND reserved
SEPARATOR reserved
SMALLINT reserved
SPATIAL reserved
SPECIFIC reserved
SQL reserved
TINYINT reserved
TINYBLOB reserved
UNLOCK reserved
UNSIGNED reserved
USE reserved
VARCHAR reserved
WHILE reserved
WRITE reserved
XOR reserved
YEAR_MONTH reserved
AS reserved
BY reserved
DO reserved
IS reserved
IN reserved
OR reserved
ON reserved
TO reserved
ALL reserved
AND reserved
ANY reserved
ADD reserved
KEY reserved
NOT reserved
SET reserved
ASC reserved
TOP reserved
END reserved
DESC reserved
DESCRIBE reserved
LOAD DATA reserved
DUMP DATA reserved
ALL PRIVILEGES reserved
CREATE DATABASE reserved
CREATE SCHEMA reserved
SHOW DATABASES reserved
CREATE USER reserved
GRANT OPTION reserved
SYSTEM reserved
INTO reserved
IGNORE reserved
LEFT reserved
NULL reserved
TRUE reserved
LIKE reserved
DROP reserved
JOIN reserved
FROM reserved
OPEN reserved
CASE reserved
WHEN reserved
THEN reserved
ELSE reserved
SOME reserved
FULL reserved
WITH reserved
FALSE reserved
ALTER reserved
SHOW reserved
RIGHT reserved
TABLE reserved
TABLES reserved
WHERE reserved
USING reserved
UNION reserved
GROUP reserved
GRANT reserved
BEGIN reserved
INDEX reserved
INDEXES reserved
KEYS reserved
INNER reserved
LIMIT reserved
OUTER reserved
ORDER reserved
REVOKE reserved
DELETE reserved
CREATE reserved
UNIQUE reserved
SELECT reserved
OFFSET reserved
EXISTS reserved
HAVING reserved
INSERT reserved
UPDATE reserved
VALUES reserved
ESCAPE reserved
WITHIN reserved
COLUMN reserved
COLUMNS reserved
NULLS reserved
FIRST reserved
LAST reserved
ROWS reserved
RANGE reserved
UNBOUNDED reserved
PRECEDING reserved
FOLLOWING reserved
CURRENT reserved
ROW reserved
KEEP reserved
EXPLAIN reserved
PRIMARY reserved
NATURAL reserved
REPLACE reserved
BETWEEN reserved
INTERVAL reserved
CONTAINS reserved
TRUNCATE reserved
DISTINCT reserved
DATABASE reserved
TABLEGROUP reserved
IF EXISTS reserved
INTERSECT reserved
MINUS reserved
OVER reserved
PROCEDURE reserved
ADDONINDEX reserved
PARTITION BY reserved
IF NOT EXISTS reserved
PARTITION NUM reserved
SUBPARTITION BY reserved
SUBPARTITION NUM reserved
PARTITION OPTIONS reserved
SUBPARTITION OPTIONS reserved
ENGINE reserved
OPTIONS reserved
OVERWRITE reserved
PROPERTIES reserved
DIMENSION reserved
CLUSTERED BY reserved
MODIFY COLUMN reserved
SET CONFIG reserved
GET CONFIG reserved
SEPARATOR reserved
KILL reserved
CACHED reserved

MPP查询语句保留字

The following table lists all of the keywords that are reserved in AnalyticDB MPP, along with their status in the SQL standard. These reserved keywords must be quoted (using double quotes) in order to be used as an identifier.

保留字 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
CURRENT_DATE reserved reserved
CURRENT_TIME reserved reserved
CURRENT_TIMESTAMP 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
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
LOCALTIMESTAMP reserved
NATURAL reserved reserved
NORMALIZE reserved
NOT reserved reserved
NULL reserved reserved
ON reserved reserved
OR reserved reserved
ORDER reserved reserved
OUTER reserved reserved
PREPARE reserved reserved
RECURSIVE reserved
RIGHT reserved reserved
ROLLUP reserved
SELECT reserved reserved
TABLE reserved reserved
THEN reserved reserved
TRUE reserved reserved
UESCAPE reserved
UNION reserved reserved
UNNEST reserved
USING reserved reserved
VALUES reserved reserved
WHEN reserved reserved
WHERE reserved reserved
WITH reserved reserved