Forbidden keywords
Updated at:
ApsaraDB RDS prohibits certain keywords as identifiers for databases, accounts, tables, and columns. These include standard SQL reserved words and RDS-specific internal identifiers.
ApsaraDB RDS for MySQL
Some keywords in this list are RDS-specific internal identifiers — such as EAGLEYE, GUEST, GOTO, LABEL, MYSQL, REPLICATOR, ROOT, TEST, and XTRABAK — that are not reserved in standard MySQL. ApsaraDB RDS reserves these for internal system accounts and components.
| Category | Keyword |
|---|---|
| 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
Some keywords in this list are RDS-specific internal identifiers — such as AURORA, EAGLEYE, GALAXY, SA, ROOT, ADMIN, ADMINISTRATOR, BULKADMIN, DBCREATOR, DISKADMIN, DISTRIBUTION, DUMMY, MSSQLD, MSSQLSYSTEMRESOURCE, PROCESSADMIN, SECURITYADMIN, SERVERADMIN, SETUPADMIN, and SYSADMIN — that are not reserved in standard SQL Server. ApsaraDB RDS reserves these for internal system accounts and components.
| Category | Keyword |
|---|---|
| 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
For the complete list of reserved words, see the PostgreSQL official documentation.
Is this page helpful?