ApsaraDB RDS prohíbe el uso de ciertas palabras clave como identificadores de bases de datos, cuentas, tablas y columnas. Entre ellas se incluyen las palabras reservadas estándar de SQL y los identificadores internos específicos de RDS.
ApsaraDB RDS for MySQL
Algunas palabras clave de esta lista son identificadores internos específicos de RDS —como EAGLEYE, GUEST, GOTO, LABEL, MYSQL, REPLICATOR, ROOT, TEST y XTRABAK— que no están reservados en MySQL estándar. ApsaraDB RDS los reserva para cuentas y componentes internos del sistema.
|
**Categoría** |
**Palabra clave** |
|
A |
ACTION, ADD, ADMIN, ALL, ALTER, ANALYZE, AND, AS, ASC, ASENSITIVE |
|
B |
BEFORE, BETWEEN, BIGINT, BINARY, BLOB, BOTH, BY |
|
C |
CALL, CASCADE, CASE, CHANGE, CHAR, CHARACTER, CHECK, COLLATE, COLUMN, CONDITION, CONNECTION, CONSTRAINT, CONTINUE, CONVERT, CREATE, CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR |
|
D |
DATABASE, DATABASES, DAY_HOUR, DAY_MICROSECOND, DAY_MINUTE, DAY_SECOND, DEC, DECIMAL, DECLARE, DEFAULT, DELAYED, DELETE, DESC, DESCRIBE, DETERMINISTIC, DISTINCT, DISTINCTROW, DIV, DOUBLE, DROP, DUAL |
|
E |
EACH, EAGLEYE, ELSE, ELSEIF, ENCLOSED, ESCAPED, EXISTS, EXIT, EXPLAIN |
|
F |
FALSE, FETCH, FLOAT, FLOAT4, FLOAT8, FOR, FORCE, FOREIGN, FROM, FULLTEXT |
|
G |
GOTO, GRANT, GROUP, GUEST |
|
H |
HAVING, HIGH_PRIORITY, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND |
|
I |
IF, IGNORE, IN, INDEX, INFILE, INFORMATION_SCHEMA, INNER, INOUT, INSENSITIVE, INSERT, INT, INT1, INT2, INT3, INT4, INT8, INTEGER, INTERVAL, INTO, IS, ITERATE |
|
J |
JOIN |
|
K |
KEY, KEYS, KILL |
|
L |
LABEL, LEADING, LEAVE, LEFT, LIKE, LIMIT, LINEAR, LINES, LOAD, LOCALTIME, LOCALTIMESTAMP, LOCK, LONG, LONG, LONGBLOB, LONGTEXT, LOOP, LOW_PRIORITY |
|
M |
MATCH, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MIDDLEINT, MINUTE_MICROSECOND, MINUTE_SECOND, MOD, MODIFIES, MYSQL |
|
N |
NATURAL, NO_WRITE_TO_BINLOG, NOT, NULL, NUMERIC |
|
O |
ON, OPTIMIZE, OPTION, OPTIONALLY, OR, ORDER, OUT, OUTER, OUTFILE |
|
P |
PERFORMANCE_SCHEMA, PRECISION, PRIMARY, PROCEDURE, PURGE |
|
R |
RAID0, RANGE, READ, READS, REAL, REFERENCES, REGEXP, RELEASE, RENAME, REPEAT, REPLACE, REPLICATOR, REQUIRE, RESTRICT, RETURN, REVOKE, RIGHT, RLIKE, ROOT |
|
S |
SCHEMA, SCHEMAS, SECOND_MICROSECOND, SELECT, SENSITIVE, SEPARATOR, SET, SHOW, SMALLINT, SPATIAL, SPECIFIC, SQL, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS, SQL_SMALL_RESULT, SQLEXCEPTION, SQLSTATE, SQLWARNING, SSL, STARTING, STRAIGHT_JOIN |
|
T |
TABLE, TERMINATED, TEST, THEN, TINYBLOB, TINYINT, TINYTEXT, TO, TRAILING, TRIGGER, TRUE |
|
U |
UNDO, UNION, UNIQUE, UNLOCK, UNSIGNED, UPDATE, USAGE, USE, USING, UTC_DATE, UTC_TIME, UTC_TIMESTAMP |
|
V |
VALUES, VARBINARY, VARCHAR, VARCHARACTER, VARYING |
|
W |
WHEN, WHERE, WHILE, WITH, WRITE |
|
X |
X509, XOR, XTRABAK |
|
Y |
YEAR_MONTH |
|
Z |
ZEROFILL |
ApsaraDB RDS for SQL Server
Algunas palabras clave de esta lista son identificadores internos específicos de RDS —como AURORA, EAGLEYE, GALAXY, SA, ROOT, ADMIN, ADMINISTRATOR, BULKADMIN, DBCREATOR, DISKADMIN, DISTRIBUTION, DUMMY, MSSQLD, MSSQLSYSTEMRESOURCE, PROCESSADMIN, SECURITYADMIN, SERVERADMIN, SETUPADMIN y SYSADMIN— que no están reservados en SQL Server estándar. ApsaraDB RDS los reserva para cuentas y componentes internos del sistema.
|
**Categoría** |
**Palabra clave** |
|
A |
ADD, ADMIN, ADMINISTRATOR, ALL, ALTER, AND, ANY, AS, ASC, AURORA, AUTHORIZATION |
|
B |
BACKUP, BEGIN, BETWEEN, BREAK, BROWSE, BULK, BULKADMIN, BY |
|
C |
CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COALESCE, COLLATE, COLUMN, COMMIT, COMPUTE, CONSTRAINT, CONTAINS, CONTAINSTABLE, CONTINUE, CONTINUE, CONVERT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR |
|
D |
DATABASE, DBCC, DBCREATOR, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISKADMIN, DISTINCT, DISTRIBUTED, DISTRIBUTION, DOUBLE, DROP, DUMMY, DUMP |
|
E |
EAGLEYE, ELSE, END, ERRLVL, ESCAPE, EXCEPT, EXEC, EXECUTE, EXISTS, EXIT |
|
F |
FETCH, FILE, FILLFACTOR, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION |
|
G |
GALAXY, GOTO, GRANT, GROUP, GUEST |
|
H |
HAVING, HOLDLOCK |
|
I |
IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IF, IN, INDEX, INNER, INSERT, INTERSECT, INTO, IS |
|
J |
JOIN |
|
K |
KEY, KILL |
|
L |
LEFT, LIKE, LINENO, LOAD |
|
M |
MASTER, MODEL, MSDB, MSSQLD, MSSQLSYSTEMRESOURCE |
|
N |
NATIONAL, NOCHECK, NONCLUSTERED, NOT, NULL, NULLIF |
|
O |
OF, OFF, OFFSETS, ON, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, OR, ORDER, OUTER, OVER |
|
P |
PERCENT, PLAN, PRECISION, PRIMARY, PRINT, PROC, PROCEDURE, PROCESSADMIN, PUBLIC, PUBLIC |
|
R |
RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPLICATION, RESTORE, RESTRICT, RETURN, REVOKE, RIGHT, ROLLBACK, ROOT, ROWCOUNT, ROWGUIDCOL, RULE |
|
S |
SA, SAVE, SCHEMA, SECURITYADMIN, SELECT, SERVERADMIN, SESSION_USER, SET, SETUPADMIN, SETUSER, SHUTDOWN, SOME, STATISTICS, SYSADMIN, SYSTEM_USER |
|
T |
TABLE, TEMPDB, TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, TSEQUAL |
|
U |
UNION, UNIQUE, UPDATE, UPDATETEXT, USE, USER |
|
V |
VALUES, VARYING, VIEW |
|
W |
WAITFOR, WHEN, WHERE, WHILE, WITH, WRITETEXT |
ApsaraDB RDS for PostgreSQL
Para ver la lista completa de palabras reservadas, consulte la documentación oficial de PostgreSQL.