| 开头字母 | 公共 | Oracle | DB2 | Sybase | SQLServer | Mysql |
| A | ADD | ACCESS | ALIAS | ANY | ANY | ANALYZE |
| ALL | ANY | ALLOCATE | ASC | ASC | ASC | |
| ALTER | ASC | ALLOW | AUTHORIZATION | ASENSITIVE | ||
| AND | AUDIT | ALTER | ||||
| AS | ANY | |||||
| APPLICATION | ||||||
| ASSOCIATE | ||||||
| ASUTIME | ||||||
| AUDIT | ||||||
| AUTHORIZATION | ||||||
| AUX | ||||||
| AUXILIARY | ||||||
| B | BETWEEN | BY | BEFORE | BACKUP | BACKUP | BEFORE |
| BEGIN | BEGIN | BEGIN | BIGINT | |||
| BINARY | BIGINT | BREAK | BINARY | |||
| BUFFERPOOL | BINARY | BROWSE | BLOB | |||
| BY | BULK | BOTH | ||||
| BY | BY | |||||
| C | CHECK | CHAR | CACHE | CALL | CASCADE | CALL |
| CREATE | CLUSTER | CALL | CASCADE | CASE | CASCADE | |
| COLUMN | CALLED | CASE | CHECKPOINT | CASE | ||
| COMMENT | CAPTURE | CAST | CLOSE | CHANGE | ||
| COMPRESS | CARDINALITY | CHAR | CLUSTERED | CHAR | ||
| CONNECT | CASCADED | CHAR_CONVERT | COALESCE | CHARACTER | ||
| CURRENT | CASE | CHARACTER | COLLATE | COLLATE | ||
| CAST | CHECKPOINT | COLUMN | COLUMN | |||
| CCSID | CLOSE | COMMIT | CONDITION | |||
| CHAR | COMMENT | COMPUTE | CONNECTION | |||
| CHARACTER | COMMIT | CONSTRAINT | CONSTRAINT | |||
| CLOSE | CONNECT | CONTAINS | CONTINUE | |||
| CLUSTER | CONSTRAINT | CONTAINSTABLE | CONVERT | |||
| COLLECTION | CONTINUE | CONTINUE | CROSS | |||
| COLLID | CONVERT | CONVERT | CURRENT_DATE | |||
| COLUMN | CROSS | CROSS | CURRENT_TIME | |||
| COMMENT | CURRENT | CURRENT | CURRENT_TIMESTAMP | |||
| COMMIT | CURSOR | CURRENT_DATE | CURRENT_USER | |||
| CONCAT | CURRENT_TIME | CURSOR | ||||
| CONDITION | CURRENT_TIMESTAMP | |||||
| CONNECT | CURRENT_USER | |||||
| CONNECTION | CURSOR | |||||
| CONSTRAINT | ||||||
| CONTAINS | ||||||
| CONTINUE | ||||||
| COUNT | ||||||
| COUNT_BIG | ||||||
| CROSS | ||||||
| CURRENT | ||||||
| CURRENT_DATE | ||||||
| CURRENT_LC_CTYPE | ||||||
| CURRENT_PATH | ||||||
| CURRENT_SERVER | ||||||
| CURRENT_TIME | ||||||
| CURRENT_TIMESTAMP | ||||||
| CURRENT_TIMEZONE | ||||||
| CURRENT_USER | ||||||
| CURSOR | ||||||
| CYCLE | ||||||
| D | DEFAULT | DATE | DATA | DATE | DATABASE | DATABASE |
| DELETE | DECIMAL | DATABASE | DBSPACE | DBCC | DATABASES | |
| DISTINCT | DESC | DAY | DEALLOCATE | DEALLOCATE | DAY_HOUR | |
| DROP | DAYS | DEC | DECLARE | DAY_MICROSECOND | ||
| DB2GENERAL | DECIMAL | DENY | DAY_MINUTE | |||
| DB2GENRL | DECLARE | DESC | DAY_SECOND | |||
| DB2SQL | DESC | DISK | DEC | |||
| DBINFO | DISABLE | DISTRIBUTED | DECIMAL | |||
| DECLARE | DO | DOUBLE | DECLARE | |||
| DEFAULTS | DOUBLE | DUMMY | DELAYED | |||
| DEFINITION | DYNAMIC | DUMP | DESC | |||
| DESCRIPTOR | DESCRIBE | |||||
| DETERMINISTIC | DETERMINISTIC | |||||
| DISALLOW | DISTINCTROW | |||||
| DISCONNECT | DIV | |||||
| DO | DOUBLE | |||||
| DOUBLE | DUAL | |||||
| DSNHATTR | ||||||
| DSSIZE | ||||||
| DYNAMIC | ||||||
| E | ELSE | EXCLUSIVE | EACH | ELSEIF | END | EACH |
| EXISTS | EDITPROC | ENABLE | ERRLVL | ELSEIF | ||
| ELSEIF | ENCRYPTED | ESCAPE | ENCLOSED | |||
| ENCODING | END | EXCEPT | ESCAPED | |||
| END | ENDIF | EXEC | EXISTS | |||
| END-EXEC | ESCAPE | EXECUTE | EXIT | |||
| END-EXEC1 | EXCEPTION | EXISTS | EXPLAIN | |||
| ERASE | EXEC | EXIT | ||||
| ESCAPE | ||||||
| EXCEPT | ||||||
| EXCEPTION | ||||||
| EXCLUDING | ||||||
| EXECUTE | ||||||
| EXISTS | ||||||
| EXIT | ||||||
| EXTERNAL | ||||||
| F | FILE | FENCED | EXECUTE | FETCH | FETCH | |
| FLOAT | FETCH | EXISTING | FILE | FLOAT | ||
| FOR | FIELDPROC | EXISTS | FILLFACTOR | FLOAT4 | ||
| FROM | FILE | EXTERNLOGIN | FOR | FLOAT8 | ||
| FINAL | FOREIGN | FOREIGN | FOR | |||
| FOR | FORWARD | FREETEXT | FORCE | |||
| FOREIGN | FROM | FREETEXTTABLE | FOREIGN | |||
| FREE | FULL | FROM | FROM | |||
| FROM | FULL | FULLTEXT | ||||
| FULL | FUNCTION | FALSE | ||||
| FUNCTION | ||||||
| G | GROUP | GENERAL | GOTO | GOTO | GOTO | |
| GRANT | GENERATED | |||||
| GET | ||||||
| GLOBAL | ||||||
| GO | ||||||
| GOTO | ||||||
| GRAPHIC | ||||||
| H | HAVING | HANDLER | HOLDLOCK | HOLDLOCK | HIGH_PRIORITY | |
| HOLD | HOUR_MICROSECOND | |||||
| HOUR | HOUR_MINUTE | |||||
| HOURS | HOUR_SECOND | |||||
| I | IN | IDENTIFIED | IDENTITY | IDENTIFIED | IDENTITY | IF |
| INDEX | IMMEDIATE | IF | IF | IDENTITY_INSERT | IGNORE | |
| INSERT | INCREMENT | IMMEDIATE | INNER | IDENTITYCOL | INFILE | |
| INTO | INITIAL | INCLUDING | INOUT | IF | INNER | |
| IS | INTEGER | INCREMENT | INSENSITIVE | INNER | INOUT | |
| INTERSECT | INDICATOR | INSTALL | INTERSECT | INSENSITIVE | ||
| INHERIT | INSTEAD | INT | ||||
| INNER | INT | INT1 | ||||
| INOUT | INTEGER | INT2 | ||||
| INSENSITIVE | INTEGRATED | INT3 | ||||
| INTEGRITY | IQ | INT4 | ||||
| ISOBID | ISOLATION | INT8 | ||||
| ISOLATION | INTEGER | |||||
| ITERATE | INTERVAL | |||||
| ITERATE | ||||||
| J | JAR | JOIN | JOIN | JOIN | ||
| JAVA | ||||||
| JOIN | ||||||
| K | KEY | KEY | KEY | KEY | ||
| KILL | KEYS | |||||
| KILL | ||||||
| L | LIKE | LEVEL | LABEL | LEFT | LEFT | LABEL |
| LOCK | LANGUAGE | LOCK | LINENO | LEADING | ||
| LONG | LC_CTYPE | LOGIN | LOAD | LEAVE | ||
| LEAVE | LONG | LEFT | ||||
| LEFT | LIMIT | |||||
| LINKTYPE | LINEAR | |||||
| LOCAL | LINES | |||||
| LOCALE | LOAD | |||||
| LOCATOR | LOCALTIME | |||||
| LOCATORS | LOCALTIMESTAMP | |||||
| LOCK | LOCK | |||||
| LOCKMAX | LONG | |||||
| LOCKSIZE | LONGBLOB | |||||
| LONG | LONGTEXT | |||||
| LOOP | LOOP | |||||
| LOW_PRIORITY | ||||||
| M | MAXEXTENTS | MAXVALUE | MATCH | MATCH | ||
| MINUS | MICROSECOND | MEMBERSHIP | MEDIUMBLOB | |||
| MLSLABEL | MICROSECONDS | MESSAGE | MEDIUMINT | |||
| MODE | MINUTE | MODE | MEDIUMTEXT | |||
| MODIFY | MINUTES | MODIFY | MIDDLEINT | |||
| MINVALUE | MINUTE_MICROSECOND | |||||
| MODE | MINUTE_SECOND | |||||
| MODIFIES | MOD | |||||
| MONTH | MODIFIES | |||||
| MONTHS | ||||||
| N | NOT | NOAUDIT | NEW | NATURAL | NATIONAL | NATURAL |
| NULL | NOCOMPRESS | NEW_TABLE | NEW | NOCHECK | NO_WRITE_TO_BINLOG | |
| NOWAIT | NO | NO | NONCLUSTERED | NUMERIC | ||
| NUMBER | NOCACHE | NOTIFY | NULLIF | |||
| NOCYCLE | NUMERIC | |||||
| NODENAME | ||||||
| NODENUMBER | ||||||
| NOMAXVALUE | ||||||
| NOMINVALUE | ||||||
| NOORDER | ||||||
| NULLS | ||||||
| NUMPARTS | ||||||
| O | OPTION | OF | OBID | OF | OF | OPTIMIZE |
| ON | OFFLINE | OF | OFF | OFF | OPTIONALLY | |
| OR | ONLINE | OLD | OPEN | OFFSETS | OUT | |
| ORDER | OLD_TABLE | OPTIONS | OPEN | OUTER | ||
| OPEN | OTHERS | OPENDATASOURCE | OUTFILE | |||
| OPTIMIZATION | OUT | OPENQUERY | ||||
| OPTIMIZE | OUTER | OPENROWSET | ||||
| OUT | OPENXML | |||||
| OUTER | OUTER | |||||
| OVERRIDING | OVER | |||||
| P | PCTFREE | PACKAGE | PASSTHROUGH | PERCENT | PRECISION | |
| PRIOR | PARAMETER | PRECISION | PLAN | PRIMARY | ||
| PRIVILEGES | PART | PREPARE | PRECISION | PROCEDURE | ||
| PUBLIC | PARTITION | PRIMARY | PRIMARY | PURGE | ||
| PATH | ||||||
| PIECESIZE | PRIVILEGES | PROC | ||||
| PLAN | PROC | PROCEDURE | ||||
| POSITION | PROCEDURE | PUBLIC | ||||
| PRECISION | PUBLICATION | |||||
| PREPARE | ||||||
| PRIMARY | ||||||
| PRIQTY | ||||||
| PRIVILEGES | ||||||
| PROCEDURE | ||||||
| PROGRAM | ||||||
| PSID | ||||||
| Q | QUERYNO | |||||
| R | REVOKE | RAW | READ | RAISERROR | RAISERROR | RAID0 |
| RENAME | READS | READTEXT | READ | RANGE | ||
| RESOURCE | RECOVERY | REAL | READTEXT | READ | ||
| ROW | REFERENCES | REFERENCE | RECONFIGURE | READS | ||
| ROWID | REFERENCING | REFERENCES | REFERENCES | REAL | ||
| ROWNUM | RELEASE | RELEASE | REPLICATION | REFERENCES | ||
| ROWS | RENAME | REMOTE | RESTORE | REGEXP | ||
| REPEAT | REMOVE | RESTRICT | RELEASE | |||
| RESET | RENAME | RETURN | RENAME | |||
| RESIGNAL | RESOURCE | RIGHT | REPEAT | |||
| RESTART | RESTORE | ROLLBACK | REPLACE | |||
| RESTRICT | RESTRICT | ROWCOUNT | REQUIRE | |||
| RESULT | RETURN | ROWGUIDCOL | RESTRICT | |||
| RESULT_SET_LOCATOR | RIGHT | RULE | RETURN | |||
| RETURN | ROLLBACK | RIGHT | ||||
| RETURNS | RLIKE | |||||
| RIGHT | ||||||
| ROLLBACK | ||||||
| ROUTINE | ||||||
| ROW | ||||||
| ROWS | ||||||
| RRN | ||||||
| RUN | ||||||
| S | SELECT | SESSION | SAVEPOINT | SAVE | SAVE | SCHEMA |
| SET | SHARE | SCHEMA | SAVEPOINT | SCHEMA | SCHEMAS | |
| SIZE | SCRATCHPAD | SCHEDULE | SESSION_USER | SECOND_MICROSECOND | ||
| SMALLINT | SECOND | SCROLL | SETUSER | SENSITIVE | ||
| START | SECONDS | SESSION | SHUTDOWN | SEPARATOR | ||
| SUCCESSFUL | SECQTY | SETUSER | SOME | SHOW | ||
| SYNONYM | SECURITY | SHARE | STATISTICS | SMALLINT | ||
| SYSDATE | SENSITIVE | SMALLINT | SYSTEM_USER | SPATIAL | ||
| SIGNAL | SOME | SPECIFIC | ||||
| SIMPLE | SQLCODE | SQL | ||||
| SOME | SQLSTATE | SQL_BIG_RESULT | ||||
| SOURCE | START | SQL_CALC_FOUND_ROWS | ||||
| SPECIFIC | STOP | SQL_SMALL_RESULT | ||||
| SQL | SUBTRANS | SQLEXCEPTION | ||||
| SQLID | SYNCHRONIZE | SQLSTATE | ||||
| STANDARD | SYNTAX_ERROR | SQLWARNING | ||||
| START | SSL | |||||
| STATIC | STARTING | |||||
| STAY | STRAIGHT_JOIN | |||||
| STOGROUP | ||||||
| STORES | ||||||
| STYLE | ||||||
| SUBPAGES | ||||||
| SUBSTRING | ||||||
| SYNONYM | ||||||
| SYSFUN | ||||||
| SYSIBM | ||||||
| SYSPROC | ||||||
| SYSTEM | ||||||
| T | TABLE | TABLESPACE | TEMPORARY | TEXTSIZE | TERMINATED | |
| THEN | TRANSACTION | TIME | TOP | TINYBLOB | ||
| TO | TRIM | TIMESTAMP | TRAN | TINYINT | ||
| TRIGGER | TYPE | TINYINT | TRANSACTION | TINYTEXT | ||
| TOP | TRUNCATE | TRAILING | ||||
| TRAN | TSEQUAL | TRUE | ||||
| TRUNCATE | ||||||
| TSEQUAL | ||||||
| U | UNION | UID | UNDO | UNKNOWN | UPDATETEXT | UNDO |
| UNIQUE | USER | UNTIL | UNSIGNED | USE | UNLOCK | |
| UPDATE | USAGE | USER | USER | UNSIGNED | ||
| USER | USING | USAGE | ||||
| USING | USE | |||||
| USING | ||||||
| UTC_DATE | ||||||
| UTC_TIME | ||||||
| UTC_TIMESTAMP | ||||||
| V | VALUES | VALIDATE | VALIDPROC | VALIDATE | VARYING | VARBINARY |
| VARCHAR | VARIABLE | VARBINARY | VIEW | VARCHAR | ||
| VARCHAR2 | VARIANT | VARCHAR | VARCHARACTER | |||
| VIEW | VCAT | VARIABLE | VARYING | |||
| VIEW | VARYING | |||||
| VOLUMES | VIEW | |||||
| W | WHERE | WHENEVER | WHEN | WHEN | WAITFOR | WHEN |
| WITH | WHILE | WHILE | WHEN | WHILE | ||
| WLM | WORK | WHILE | WRITE | |||
| WRITE | WRITETEXT | WRITETEXT | ||||
| X | X509 | |||||
| XOR | ||||||
| Y | YEAR | YEAR_MONTH | ||||
| YEARS | ||||||
| Z | ZEROFILL |
常用数据库保留字列表
最新推荐文章于 2023-05-30 13:23:18 发布
本文详细列举了常见数据库系统的保留字,并讨论了在编程和设计时如何避免与这些保留字冲突,确保数据库操作的稳定性和安全性。同时,提到了在处理异常、描述符、授权、时区和OpenXML等特定数据库功能时需要注意的事项。
970

被折叠的 条评论
为什么被折叠?



