ApsaraDB RDS interdit l'utilisation de certains mots clés comme identifiants pour les bases de données, les comptes, les tables et les colonnes. Cette liste comprend les mots réservés du langage SQL standard ainsi que des identifiants internes spécifiques à RDS.
ApsaraDB RDS for MySQL
Certains mots clés de cette liste sont des identifiants internes spécifiques à RDS, tels que EAGLEYE, GUEST, GOTO, LABEL, MYSQL, REPLICATOR, ROOT, TEST et XTRABAK. Bien qu'ils ne soient pas réservés dans MySQL standard, ApsaraDB RDS les réserve pour ses comptes système et composants internes.
| **Catégorie** | **Mot clé** |
|---|---|
| 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
Certains mots clés de cette liste sont des identifiants internes spécifiques à RDS, tels que AURORA, EAGLEYE, GALAXY, SA, ROOT, ADMIN, ADMINISTRATOR, BULKADMIN, DBCREATOR, DISKADMIN, DISTRIBUTION, DUMMY, MSSQLD, MSSQLSYSTEMRESOURCE, PROCESSADMIN, SECURITYADMIN, SERVERADMIN, SETUPADMIN et SYSADMIN. Bien qu'ils ne soient pas réservés dans SQL Server standard, ApsaraDB RDS les réserve pour ses comptes système et composants internes.
| **Catégorie** | **Mot clé** |
|---|---|
| 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
Pour consulter la liste complète des mots réservés, reportez-vous à la documentation officielle de PostgreSQL.