开头字母 | 公共 | 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 发布