SQL reserved words
This list includes SQL reserved words as specified in the SQL:2016 standard, and also some products' reserved words.
In SQL:2016[1] | In DB2 12.0[2] | In Mimer SQL 11.0[3] | In MySQL 8.0[4] | In Oracle Database 19[5] | In PostgreSQL 13[6] | In Microsoft SQL Server 2019[7] | In Teradata 15[8] | |
---|---|---|---|---|---|---|---|---|
ABORT | — | — | — | — | — | — | — | ![]() |
ABORTSESSION | — | — | — | — | — | — | — | ![]() |
ABS | ![]() | — | — | — | — | — | — | ![]() |
ABSOLUTE | — | — | — | — | — | — | — | ![]() |
ACCESS | — | — | — | — | ![]() | — | — | — |
ACCESSIBLE | — | — | — | ![]() | — | — | — | — |
ACCESS_LOCK | — | — | — | — | — | — | — | ![]() |
ACCOUNT | — | — | — | — | — | — | — | ![]() |
ACOS | ![]() | — | — | — | — | — | — | ![]() |
ACOSH | — | — | — | — | — | — | — | ![]() |
ACTION | — | — | — | — | — | — | — | ![]() |
ADD | — | ![]() | — | ![]() | ![]() | — | ![]() | ![]() |
ADD_MONTHS | — | — | — | — | — | — | — | ![]() |
ADMIN | — | — | — | — | — | — | — | ![]() |
AFTER | — | ![]() | — | — | — | — | — | ![]() |
AGGREGATE | — | — | — | — | — | — | — | ![]() |
ALIAS | — | — | — | — | — | — | — | ![]() |
ALL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ALLOCATE | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
ALLOW | — | ![]() | — | — | — | — | — | — |
ALTER | ![]() | — | ![]() | ![]() | ![]() | — | ![]() | ![]() |
ALTERAND | — | ![]() | — | — | — | — | — | — |
AMP | — | — | — | — | — | — | — | ![]() |
ANALYSE | — | — | — | — | — | ![]() | — | — |
ANALYZE | — | — | — | ![]() | — | ![]() | — | — |
AND | ![]() | — | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ANSIDATE | — | — | — | — | — | — | — | ![]() |
ANY | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() | ![]() |
ARE | ![]() | — | — | — | — | — | — | ![]() |
ARRAY | ![]() | ![]() | — | — | — | ![]() | — | ![]() |
ARRAY_AGG | ![]() | — | — | — | — | — | — | — |
ARRAY_EXISTS | — | ![]() | — | — | — | — | — | — |
ARRAY_MAX_CARDINALITY | ![]() | — | — | — | — | — | — | — |
AS | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ASC | — | — | — | ![]() | ![]() | ![]() | ![]() | ![]() |
ASENSITIVE | ![]() | ![]() | — | ![]() | — | — | — | — |
ASIN | ![]() | — | — | — | — | — | — | ![]() |
ASINH | — | — | — | — | — | — | — | ![]() |
ASSERTION | — | — | — | — | — | — | — | ![]() |
ASSOCIATE | — | ![]() | — | — | — | — | — | — |
ASUTIME | — | ![]() | — | — | — | — | — | — |
ASYMMETRIC | ![]() | — | ![]() | — | — | ![]() | — | — |
AT | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
ATAN | ![]() | — | — | — | — | — | — | ![]() |
ATAN2 | — | — | — | — | — | — | — | ![]() |
ATANH | — | — | — | — | — | — | — | ![]() |
ATOMIC | ![]() | — | ![]() | — | — | — | — | ![]() |
AUDIT | — | ![]() | — | — | ![]() | — | — | — |
AUTHORIZATION | ![]() | — | ![]() | — | — | ![]() | ![]() | ![]() |
AUX | — | ![]() | — | — | — | — | — | — |
AUXILIARY | — | ![]() | — | — | — | — | — | — |
AVE | — | — | — | — | — | — | — | ![]() |
AVERAGE | — | — | — | — | — | — | — | ![]() |
AVG | ![]() | — | — | — | — | — | — | ![]() |
BACKUP | — | — | — | — | — | — | ![]() | — |
BEFORE | — | ![]() | — | ![]() | — | — | — | ![]() |
BEGIN | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
BEGIN_FRAME | ![]() | — | — | — | — | — | — | — |
BEGIN_PARTITION | ![]() | — | — | — | — | — | — | — |
BETWEEN | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
BIGINT | ![]() | — | — | ![]() | — | — | — | — |
BINARY | ![]() | — | — | ![]() | — | ![]() | — | ![]() |
BIT | — | — | — | — | — | — | — | ![]() |
BLOB | ![]() | — | — | ![]() | — | — | — | ![]() |
BOOLEAN | ![]() | — | — | — | — | — | — | ![]() |
BOTH | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
BREADTH | — | — | — | — | — | — | — | ![]() |
BREAK | — | — | — | — | — | — | ![]() | — |
BROWSE | — | — | — | — | — | — | ![]() | — |
BT | — | — | — | — | — | — | — | ![]() |
BUFFERPOOL | — | ![]() | — | — | — | — | — | — |
BULK | — | — | — | — | — | — | ![]() | — |
BUT | — | — | — | — | — | — | — | ![]() |
BY | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
BYTE | — | — | — | — | — | — | — | ![]() |
BYTEINT | — | — | — | — | — | — | — | ![]() |
BYTES | — | — | — | — | — | — | — | ![]() |
CALL | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
CALLED | ![]() | — | ![]() | — | — | — | — | — |
CAPTURE | — | ![]() | — | — | — | — | — | — |
CARDINALITY | ![]() | — | — | — | — | — | — | — |
CASCADE | — | — | — | ![]() | — | — | ![]() | ![]() |
CASCADED | ![]() | ![]() | — | — | — | — | — | ![]() |
CASE | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CASESPECIFIC | — | — | — | — | — | — | — | ![]() |
CASE_N | — | — | — | — | — | — | — | ![]() |
CAST | ![]() | ![]() | ![]() | — | — | ![]() | — | ![]() |
CATALOG | — | — | — | — | — | — | — | ![]() |
CCSID | — | ![]() | — | — | — | — | — | — |
CD | — | — | — | — | — | — | — | ![]() |
CEIL | ![]() | — | — | — | — | — | — | — |
CEILING | ![]() | — | — | — | — | — | — | — |
CHANGE | — | — | — | ![]() | — | — | — | — |
CHAR | ![]() | ![]() | — | ![]() | ![]() | — | — | ![]() |
CHAR2HEXINT | — | — | — | — | — | — | — | ![]() |
CHARACTER | ![]() | ![]() | — | ![]() | — | — | — | ![]() |
CHARACTERS | — | — | — | — | — | — | — | ![]() |
CHARACTER_LENGTH | ![]() | — | — | — | — | — | — | ![]() |
CHARS | — | — | — | — | — | — | — | ![]() |
CHAR_LENGTH | ![]() | — | — | — | — | — | — | ![]() |
CHECK | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
CHECKPOINT | — | — | — | — | — | — | ![]() | ![]() |
CLASS | — | — | — | — | — | — | — | ![]() |
CLASSIFIER | ![]() | — | — | — | — | — | — | — |
CLOB | ![]() | — | — | — | — | — | — | ![]() |
CLONE | — | ![]() | — | — | — | — | — | — |
CLOSE | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
CLUSTER | — | ![]() | — | — | ![]() | — | — | ![]() |
CLUSTERED | — | — | — | — | — | — | ![]() | — |
CM | — | — | — | — | — | — | — | ![]() |
COALESCE | ![]() | — | — | — | — | — | ![]() | ![]() |
COLLATE | ![]() | — | ![]() | ![]() | — | ![]() | ![]() | ![]() |
COLLATION | — | — | — | — | — | ![]() | — | ![]() |
COLLECT | ![]() | — | — | — | — | — | — | ![]() |
COLLECTION | — | ![]() | — | — | — | — | — | — |
COLLID | — | ![]() | — | — | — | — | — | — |
COLUMN | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
COLUMN_VALUE | — | — | — | — | ![]() | — | — | — |
COMMENT | — | ![]() | — | — | ![]() | — | — | ![]() |
COMMIT | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
COMPLETION | — | — | — | — | — | — | — | ![]() |
COMPRESS | — | — | — | — | ![]() | — | — | ![]() |
COMPUTE | — | — | — | — | — | — | ![]() | — |
CONCAT | — | ![]() | — | — | — | — | — | — |
CONCURRENTLY | — | — | — | — | — | ![]() | — | — |
CONDITION | ![]() | ![]() | ![]() | ![]() | — | — | — | — |
CONNECT | ![]() | ![]() | ![]() | — | ![]() | — | — | ![]() |
CONNECTION | — | ![]() | — | — | — | — | — | ![]() |
CONSTRAINT | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CONSTRAINTS | — | — | — | — | — | — | — | ![]() |
CONSTRUCTOR | — | — | — | — | — | — | — | ![]() |
CONTAINS | ![]() | ![]() | — | — | — | — | ![]() | — |
CONTAINSTABLE | — | — | — | — | — | — | ![]() | — |
CONTENT | — | ![]() | — | — | — | — | — | — |
CONTINUE | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
CONVERT | ![]() | — | — | ![]() | — | — | ![]() | — |
CONVERT_TABLE_HEADER | — | — | — | — | — | — | — | ![]() |
COPY | ![]() | — | — | — | — | — | — | — |
CORR | ![]() | — | — | — | — | — | — | ![]() |
CORRESPONDING | ![]() | — | ![]() | — | — | — | — | ![]() |
COS | ![]() | — | — | — | — | — | — | ![]() |
COSH | ![]() | — | — | — | — | — | — | ![]() |
COUNT | ![]() | — | — | — | — | — | — | ![]() |
COVAR_POP | ![]() | — | — | — | — | — | — | ![]() |
COVAR_SAMP | ![]() | — | — | — | — | — | — | ![]() |
CREATE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
CROSS | ![]() | — | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CS | — | — | — | — | — | — | — | ![]() |
CSUM | — | — | — | — | — | — | — | ![]() |
CT | — | — | — | — | — | — | — | ![]() |
CUBE | ![]() | ![]() | — | ![]() | — | — | — | ![]() |
CUME_DIST | ![]() | — | — | ![]() | — | — | — | — |
CURRENT | ![]() | ![]() | ![]() | — | ![]() | — | ![]() | ![]() |
CURRENT_CATALOG | ![]() | — | — | — | — | ![]() | — | — |
CURRENT_DATE | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CURRENT_DEFAULT_TRANSFORM_GROUP | ![]() | — | — | — | — | — | — | — |
CURRENT_LC_CTYPE | — | ![]() | — | — | — | — | — | — |
CURRENT_PATH | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
CURRENT_ROLE | ![]() | — | — | — | — | ![]() | — | ![]() |
CURRENT_ROW | ![]() | — | — | — | — | — | — | — |
CURRENT_SCHEMA | ![]() | ![]() | — | — | — | ![]() | — | — |
CURRENT_TIME | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CURRENT_TIMESTAMP | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CURRENT_TRANSFORM_GROUP_FOR_TYPE | ![]() | — | — | — | — | — | — | — |
CURRENT_USER | ![]() | — | ![]() | ![]() | — | ![]() | ![]() | ![]() |
CURRVAL | — | ![]() | — | — | — | — | — | — |
CURSOR | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
CV | — | — | — | — | — | — | — | ![]() |
CYCLE | ![]() | — | — | — | — | — | — | ![]() |
DATA | — | ![]() | — | — | — | — | — | ![]() |
DATABASE | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
DATABASES | — | — | — | ![]() | — | — | — | — |
DATABLOCKSIZE | — | — | — | — | — | — | — | ![]() |
DATE | ![]() | — | — | — | ![]() | — | — | ![]() |
DATEFORM | — | — | — | — | — | — | — | ![]() |
DAY | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
DAYS | — | ![]() | — | — | — | — | — | — |
DAY_HOUR | — | — | — | ![]() | — | — | — | — |
DAY_MICROSECOND | — | — | — | ![]() | — | — | — | — |
DAY_MINUTE | — | — | — | ![]() | — | — | — | — |
DAY_SECOND | — | — | — | ![]() | — | — | — | — |
DBCC | — | — | — | — | — | — | ![]() | — |
DBINFO | — | ![]() | — | — | — | — | — | — |
DEALLOCATE | ![]() | — | ![]() | — | — | — | ![]() | ![]() |
DEC | ![]() | — | — | ![]() | — | — | — | ![]() |
DECFLOAT | ![]() | — | — | — | — | — | — | — |
DECIMAL | ![]() | — | — | ![]() | ![]() | — | — | ![]() |
DECLARE | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
DEFAULT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DEFERRABLE | — | — | — | — | — | ![]() | — | ![]() |
DEFERRED | — | — | — | — | — | — | — | ![]() |
DEFINE | ![]() | — | — | — | — | — | — | — |
DEGREES | — | — | — | — | — | — | — | ![]() |
DEL | — | — | — | — | — | — | — | ![]() |
DELAYED | — | — | — | ![]() | — | — | — | — |
DELETE | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
DENSE_RANK | ![]() | — | — | ![]() | — | — | — | — |
DENY | — | — | — | — | — | — | ![]() | — |
DEPTH | — | — | — | — | — | — | — | ![]() |
DEREF | ![]() | — | — | — | — | — | — | ![]() |
DESC | — | — | — | ![]() | ![]() | ![]() | ![]() | ![]() |
DESCRIBE | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
DESCRIPTOR | — | ![]() | — | — | — | — | — | ![]() |
DESTROY | — | — | — | — | — | — | — | ![]() |
DESTRUCTOR | — | — | — | — | — | — | — | ![]() |
DETERMINISTIC | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
DIAGNOSTIC | — | — | — | — | — | — | — | ![]() |
DIAGNOSTICS | — | — | — | — | — | — | — | ![]() |
DICTIONARY | — | — | — | — | — | — | — | ![]() |
DISABLE | — | ![]() | — | — | — | — | — | — |
DISABLED | — | — | — | — | — | — | — | ![]() |
DISALLOW | — | ![]() | — | — | — | — | — | — |
DISCONNECT | ![]() | — | ![]() | — | — | — | — | ![]() |
DISK | — | — | — | — | — | — | ![]() | — |
DISTINCT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
DISTINCTROW | — | — | — | ![]() | — | — | — | — |
DISTRIBUTED | — | — | — | — | — | — | ![]() | — |
DIV | — | — | — | ![]() | — | — | — | — |
DO | ![]() | ![]() | ![]() | — | — | ![]() | — | ![]() |
DOCUMENT | — | ![]() | — | — | — | — | — | — |
DOMAIN | — | — | — | — | — | — | — | ![]() |
DOUBLE | ![]() | ![]() | — | ![]() | — | — | ![]() | ![]() |
DROP | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
DSSIZE | — | ![]() | — | — | — | — | — | — |
DUAL | — | — | — | ![]() | — | — | — | ![]() |
DUMP | — | — | — | — | — | — | ![]() | ![]() |
DYNAMIC | ![]() | ![]() | — | — | — | — | — | ![]() |
EACH | ![]() | — | — | ![]() | — | — | — | ![]() |
ECHO | — | — | — | — | — | — | — | ![]() |
EDITPROC | — | ![]() | — | — | — | — | — | — |
ELEMENT | ![]() | — | — | — | — | — | — | — |
ELSE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ELSEIF | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
EMPTY | ![]() | — | — | ![]() | — | — | — | — |
ENABLED | — | — | — | — | — | — | — | ![]() |
ENCLOSED | — | — | — | ![]() | — | — | — | — |
ENCODING | — | ![]() | — | — | — | — | — | — |
ENCRYPTION | — | ![]() | — | — | — | — | — | — |
END | ![]() | ![]() | ![]() | — | — | ![]() | ![]() | ![]() |
END-EXEC | ![]() | ![]() | — | — | — | — | — | ![]() |
ENDING | — | ![]() | — | — | — | — | — | — |
END_FRAME | ![]() | — | — | — | — | — | — | — |
END_PARTITION | ![]() | — | — | — | — | — | — | — |
EQ | — | — | — | — | — | — | — | ![]() |
EQUALS | ![]() | — | — | — | — | — | — | ![]() |
ERASE | — | ![]() | — | — | — | — | — | — |
ERRLVL | — | — | — | — | — | — | ![]() | — |
ERROR | — | — | — | — | — | — | — | ![]() |
ERRORFILES | — | — | — | — | — | — | — | ![]() |
ERRORTABLES | — | — | — | — | — | — | — | ![]() |
ESCAPE | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
ESCAPED | — | — | — | ![]() | — | — | — | — |
ET | — | — | — | — | — | — | — | ![]() |
EVERY | ![]() | — | — | — | — | — | — | ![]() |
EXCEPT | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
EXCEPTION | — | ![]() | — | — | — | — | — | ![]() |
EXCLUSIVE | — | — | — | — | ![]() | — | — | — |
EXEC | ![]() | — | — | — | — | — | ![]() | ![]() |
EXECUTE | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
EXISTS | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
EXIT | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
EXP | ![]() | — | — | — | — | — | — | ![]() |
EXPLAIN | — | ![]() | — | ![]() | — | — | — | ![]() |
EXTERNAL | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
EXTRACT | ![]() | — | — | — | — | — | — | ![]() |
FALLBACK | — | — | — | — | — | — | — | ![]() |
FALSE | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
FASTEXPORT | — | — | — | — | — | — | — | ![]() |
FENCED | — | ![]() | — | — | — | — | — | — |
FETCH | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
FIELDPROC | — | ![]() | — | — | — | — | — | — |
FILE | — | — | — | — | ![]() | — | ![]() | — |
FILLFACTOR | — | — | — | — | — | — | ![]() | — |
FILTER | ![]() | — | — | — | — | — | — | — |
FINAL | — | ![]() | — | — | — | — | — | — |
FIRST | — | ![]() | ![]() | — | — | — | — | ![]() |
FIRST_VALUE | ![]() | — | — | ![]() | — | — | — | — |
FLOAT | ![]() | — | — | ![]() | ![]() | — | — | ![]() |
FLOAT4 | — | — | — | ![]() | — | — | — | — |
FLOAT8 | — | — | — | ![]() | — | — | — | — |
FLOOR | ![]() | — | — | — | — | — | — | — |
FOR | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
FORCE | — | — | — | ![]() | — | — | — | — |
FOREIGN | ![]() | — | ![]() | ![]() | — | ![]() | ![]() | ![]() |
FORMAT | — | — | — | — | — | — | — | ![]() |
FOUND | — | — | — | — | — | — | — | ![]() |
FRAME_ROW | ![]() | — | — | — | — | — | — | — |
FREE | ![]() | ![]() | — | — | — | — | — | ![]() |
FREESPACE | — | — | — | — | — | — | — | ![]() |
FREETEXT | — | — | — | — | — | — | ![]() | — |
FREETEXTTABLE | — | — | — | — | — | — | ![]() | — |
FREEZE | — | — | — | — | — | ![]() | — | — |
FROM | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
FULL | ![]() | ![]() | ![]() | — | — | ![]() | ![]() | ![]() |
FULLTEXT | — | — | — | ![]() | — | — | — | — |
FUNCTION | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
FUSION | ![]() | — | — | — | — | — | — | — |
GE | — | — | — | — | — | — | — | ![]() |
GENERAL | — | — | — | — | — | — | — | ![]() |
GENERATED | — | ![]() | — | ![]() | — | — | — | ![]() |
GET | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
GIVE | — | — | — | — | — | — | — | ![]() |
GLOBAL | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
GO | — | ![]() | — | — | — | — | — | ![]() |
GOTO | — | ![]() | — | — | — | — | ![]() | ![]() |
GRANT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
GRAPHIC | — | — | — | — | — | — | — | ![]() |
GROUP | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
GROUPING | ![]() | — | — | ![]() | — | — | — | ![]() |
GROUPS | ![]() | — | — | ![]() | — | — | — | — |
GT | — | — | — | — | — | — | — | ![]() |
HANDLER | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
HASH | — | — | — | — | — | — | — | ![]() |
HASHAMP | — | — | — | — | — | — | — | ![]() |
HASHBAKAMP | — | — | — | — | — | — | — | ![]() |
HASHBUCKET | — | — | — | — | — | — | — | ![]() |
HASHROW | — | — | — | — | — | — | — | ![]() |
HAVING | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
HELP | — | — | — | — | — | — | — | ![]() |
HIGH_PRIORITY | — | — | — | ![]() | — | — | — | — |
HOLD | ![]() | ![]() | ![]() | — | — | — | — | — |
HOLDLOCK | — | — | — | — | — | — | ![]() | — |
HOST | — | — | — | — | — | — | — | ![]() |
HOUR | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
HOURS | — | ![]() | — | — | — | — | — | — |
HOUR_MICROSECOND | — | — | — | ![]() | — | — | — | — |
HOUR_MINUTE | — | — | — | ![]() | — | — | — | — |
HOUR_SECOND | — | — | — | ![]() | — | — | — | — |
IDENTIFIED | — | — | — | — | ![]() | — | — | — |
IDENTITY | ![]() | — | ![]() | — | — | — | ![]() | ![]() |
IDENTITYCOL | — | — | — | — | — | — | ![]() | — |
IDENTITY_INSERT | — | — | — | — | — | — | ![]() | — |
IF | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
IGNORE | — | — | — | ![]() | — | — | — | ![]() |
ILIKE | — | — | — | — | — | ![]() | — | — |
IMMEDIATE | — | ![]() | — | — | ![]() | — | — | ![]() |
IN | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
INCLUSIVE | — | ![]() | — | — | — | — | — | — |
INCONSISTENT | — | — | — | — | — | — | — | ![]() |
INCREMENT | — | — | — | — | ![]() | — | — | — |
INDEX | — | ![]() | — | ![]() | ![]() | — | ![]() | ![]() |
INDICATOR | ![]() | — | ![]() | — | — | — | — | ![]() |
INFILE | — | — | — | ![]() | — | — | — | — |
INHERIT | — | ![]() | — | — | — | — | — | — |
INITIAL | ![]() | — | — | — | ![]() | — | — | — |
INITIALIZE | — | — | — | — | — | — | — | ![]() |
INITIALLY | — | — | — | — | — | ![]() | — | ![]() |
INITIATE | — | — | — | — | — | — | — | ![]() |
INNER | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
INOUT | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
INPUT | — | — | — | — | — | — | — | ![]() |
INS | — | — | — | — | — | — | — | ![]() |
INSENSITIVE | ![]() | ![]() | — | ![]() | — | — | — | — |
INSERT | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
INSTEAD | — | — | — | — | — | — | — | ![]() |
INT | ![]() | — | — | ![]() | — | — | — | ![]() |
INT1 | — | — | — | ![]() | — | — | — | — |
INT2 | — | — | — | ![]() | — | — | — | — |
INT3 | — | — | — | ![]() | — | — | — | — |
INT4 | — | — | — | ![]() | — | — | — | — |
INT8 | — | — | — | ![]() | — | — | — | — |
INTEGER | ![]() | — | — | ![]() | ![]() | — | — | ![]() |
INTEGERDATE | — | — | — | — | — | — | — | ![]() |
INTERSECT | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() | ![]() |
INTERSECTION | ![]() | — | — | — | — | — | — | — |
INTERVAL | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
INTO | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
IO_AFTER_GTIDS | — | — | — | ![]() | — | — | — | — |
IO_BEFORE_GTIDS | — | — | — | ![]() | — | — | — | — |
IS | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ISNULL | — | — | — | — | — | ![]() | — | — |
ISOBID | — | ![]() | — | — | — | — | — | — |
ISOLATION | — | — | — | — | — | — | — | ![]() |
ITERATE | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
JAR | — | ![]() | — | — | — | — | — | — |
JOIN | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
JOURNAL | — | — | — | — | — | — | — | ![]() |
JSON_ARRAY | ![]() | — | — | — | — | — | — | — |
JSON_ARRAYAGG | ![]() | — | — | — | — | — | — | — |
JSON_EXISTS | ![]() | — | — | — | — | — | — | — |
JSON_OBJECT | ![]() | — | — | — | — | — | — | — |
JSON_OBJECTAGG | ![]() | — | — | — | — | — | — | — |
JSON_QUERY | ![]() | — | — | — | — | — | — | — |
JSON_TABLE | ![]() | — | — | ![]() | — | — | — | — |
JSON_TABLE_PRIMITIVE | ![]() | — | — | — | — | — | — | — |
JSON_VALUE | ![]() | — | — | — | — | — | — | — |
KEEP | — | ![]() | — | — | — | — | — | — |
KEY | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
KEYS | — | — | — | ![]() | — | — | — | — |
KILL | — | — | — | ![]() | — | — | ![]() | — |
KURTOSIS | — | — | — | — | — | — | — | ![]() |
LABEL | — | ![]() | — | — | — | — | — | — |
LAG | ![]() | — | — | ![]() | — | — | — | — |
LANGUAGE | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
LARGE | ![]() | — | ![]() | — | — | — | — | ![]() |
LAST | — | ![]() | — | — | — | — | — | ![]() |
LAST_VALUE | ![]() | — | — | ![]() | — | — | — | — |
LATERAL | ![]() | — | — | ![]() | — | ![]() | — | ![]() |
LC_CTYPE | — | ![]() | — | — | — | — | — | — |
LE | — | — | — | — | — | — | — | ![]() |
LEAD | ![]() | — | — | ![]() | — | — | — | — |
LEADING | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
LEAVE | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
LEFT | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
LESS | — | — | — | — | — | — | — | ![]() |
LEVEL | — | — | — | — | ![]() | — | — | ![]() |
LIKE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
LIKE_REGEX | ![]() | — | — | — | — | — | — | — |
LIMIT | — | ![]() | — | ![]() | — | ![]() | — | ![]() |
LINEAR | — | — | — | ![]() | — | — | — | — |
LINENO | — | — | — | — | — | — | ![]() | — |
LINES | — | — | — | ![]() | — | — | — | — |
LISTAGG | ![]() | — | — | — | — | — | — | — |
LN | ![]() | — | — | — | — | — | — | ![]() |
LOAD | — | — | — | ![]() | — | — | ![]() | — |
LOADING | — | — | — | — | — | — | — | ![]() |
LOCAL | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
LOCALE | — | ![]() | — | — | — | — | — | — |
LOCALTIME | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
LOCALTIMESTAMP | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
LOCATOR | — | ![]() | — | — | — | — | — | ![]() |
LOCATORS | — | ![]() | — | — | — | — | — | — |
LOCK | — | ![]() | — | ![]() | ![]() | — | — | ![]() |
LOCKING | — | — | — | — | — | — | — | ![]() |
LOCKMAX | — | ![]() | — | — | — | — | — | — |
LOCKSIZE | — | ![]() | — | — | — | — | — | — |
LOG | ![]() | — | — | — | — | — | — | ![]() |
LOG10 | ![]() | — | — | — | — | — | — | — |
LOGGING | — | — | — | — | — | — | — | ![]() |
LOGON | — | — | — | — | — | — | — | ![]() |
LONG | — | ![]() | — | ![]() | ![]() | — | — | ![]() |
LONGBLOB | — | — | — | ![]() | — | — | — | — |
LONGTEXT | — | — | — | ![]() | — | — | — | — |
LOOP | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
LOWER | ![]() | — | — | — | — | — | — | ![]() |
LOW_PRIORITY | — | — | — | ![]() | — | — | — | — |
LT | — | — | — | — | — | — | — | ![]() |
MACRO | — | — | — | — | — | — | — | ![]() |
MAINTAINED | — | ![]() | — | — | — | — | — | — |
MAP | — | — | — | — | — | — | — | ![]() |
MASTER_BIND | — | — | — | ![]() | — | — | — | — |
MASTER_SSL_VERIFY_SERVER_CERT | — | — | — | ![]() | — | — | — | — |
MATCH | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
MATCHES | ![]() | — | — | — | — | — | — | — |
MATCH_NUMBER | ![]() | — | — | — | — | — | — | — |
MATCH_RECOGNIZE | ![]() | — | — | — | — | — | — | — |
MATERIALIZED | — | ![]() | — | — | — | — | — | — |
MAVG | — | — | — | — | — | — | — | ![]() |
MAX | ![]() | — | — | — | — | — | — | ![]() |
MAXEXTENTS | — | — | — | — | ![]() | — | — | — |
MAXIMUM | — | — | — | — | — | — | — | ![]() |
MAXVALUE | — | — | — | ![]() | — | — | — | — |
MCHARACTERS | — | — | — | — | — | — | — | ![]() |
MDIFF | — | — | — | — | — | — | — | ![]() |
MEDIUMBLOB | — | — | — | ![]() | — | — | — | — |
MEDIUMINT | — | — | — | ![]() | — | — | — | — |
MEDIUMTEXT | — | — | — | ![]() | — | — | — | — |
MEMBER | ![]() | — | ![]() | — | — | — | — | — |
MERGE | ![]() | — | — | — | — | — | ![]() | ![]() |
METHOD | ![]() | — | ![]() | — | — | — | — | — |
MICROSECOND | — | ![]() | — | — | — | — | — | — |
MICROSECONDS | — | ![]() | — | — | — | — | — | — |
MIDDLEINT | — | — | — | ![]() | — | — | — | — |
MIN | ![]() | — | — | — | — | — | — | ![]() |
MINDEX | — | — | — | — | — | — | — | ![]() |
MINIMUM | — | — | — | — | — | — | — | ![]() |
MINUS | — | — | — | — | ![]() | — | — | ![]() |
MINUTE | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
MINUTES | — | ![]() | — | — | — | — | — | — |
MINUTE_MICROSECOND | — | — | — | ![]() | — | — | — | — |
MINUTE_SECOND | — | — | — | ![]() | — | — | — | — |
MLINREG | — | — | — | — | — | — | — | ![]() |
MLOAD | — | — | — | — | — | — | — | ![]() |
MLSLABEL | — | — | — | — | ![]() | — | — | — |
MOD | ![]() | — | — | ![]() | — | — | — | ![]() |
MODE | — | — | — | — | ![]() | — | — | ![]() |
MODIFIES | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
MODIFY | — | — | — | — | ![]() | — | — | ![]() |
MODULE | ![]() | — | ![]() | — | — | — | — | ![]() |
MONITOR | — | — | — | — | — | — | — | ![]() |
MONRESOURCE | — | — | — | — | — | — | — | ![]() |
MONSESSION | — | — | — | — | — | — | — | ![]() |
MONTH | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
MONTHS | — | ![]() | — | — | — | — | — | — |
MSUBSTR | — | — | — | — | — | — | — | ![]() |
MSUM | — | — | — | — | — | — | — | ![]() |
MULTISET | ![]() | — | — | — | — | — | — | ![]() |
NAMED | — | — | — | — | — | — | — | ![]() |
NAMES | — | — | — | — | — | — | — | ![]() |
NATIONAL | ![]() | — | ![]() | — | — | — | ![]() | ![]() |
NATURAL | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
NCHAR | ![]() | — | — | — | — | — | — | ![]() |
NCLOB | ![]() | — | — | — | — | — | — | ![]() |
NE | — | — | — | — | — | — | — | ![]() |
NESTED_TABLE_ID | — | — | — | — | ![]() | — | — | — |
NEW | ![]() | — | ![]() | — | — | — | — | ![]() |
NEW_TABLE | — | — | — | — | — | — | — | ![]() |
NEXT | — | ![]() | ![]() | — | — | — | — | ![]() |
NEXTVAL | — | ![]() | — | — | — | — | — | — |
NO | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
NOAUDIT | — | — | — | — | ![]() | — | — | — |
NOCHECK | — | — | — | — | — | — | ![]() | — |
NOCOMPRESS | — | — | — | — | ![]() | — | — | — |
NONCLUSTERED | — | — | — | — | — | — | ![]() | — |
NONE | ![]() | ![]() | — | — | — | — | — | ![]() |
NORMALIZE | ![]() | — | — | — | — | — | — | — |
NOT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
NOTNULL | — | — | — | — | — | ![]() | — | — |
NOWAIT | — | — | — | — | ![]() | — | — | ![]() |
NO_WRITE_TO_BINLOG | — | — | — | ![]() | — | — | — | — |
NTH_VALUE | ![]() | — | — | ![]() | — | — | — | — |
NTILE | ![]() | — | — | ![]() | — | — | — | — |
NULL | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
NULLIF | ![]() | — | — | — | — | — | ![]() | ![]() |
NULLIFZERO | — | — | — | — | — | — | — | ![]() |
NULLS | — | ![]() | — | — | — | — | — | — |
NUMBER | — | — | — | — | ![]() | — | — | — |
NUMERIC | ![]() | — | — | ![]() | — | — | — | ![]() |
NUMPARTS | — | ![]() | — | — | — | — | — | — |
OBID | — | ![]() | — | — | — | — | — | — |
OBJECT | — | — | — | — | — | — | — | ![]() |
OBJECTS | — | — | — | — | — | — | — | ![]() |
OCCURRENCES_REGEX | ![]() | — | — | — | — | — | — | — |
OCTET_LENGTH | ![]() | — | — | — | — | — | — | ![]() |
OF | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
OFF | — | — | — | — | — | — | ![]() | ![]() |
OFFLINE | — | — | — | — | ![]() | — | — | — |
OFFSET | ![]() | ![]() | ![]() | — | — | ![]() | — | — |
OFFSETS | — | — | — | — | — | — | ![]() | — |
OLD | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
OLD_TABLE | — | — | — | — | — | — | — | ![]() |
OMIT | ![]() | — | — | — | — | — | — | — |
ON | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ONE | ![]() | — | — | — | — | — | — | — |
ONLINE | — | — | — | — | ![]() | — | — | — |
ONLY | ![]() | — | — | — | — | ![]() | — | ![]() |
OPEN | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
OPENDATASOURCE | — | — | — | — | — | — | ![]() | — |
OPENQUERY | — | — | — | — | — | — | ![]() | — |
OPENROWSET | — | — | — | — | — | — | ![]() | — |
OPENXML | — | — | — | — | — | — | ![]() | — |
OPERATION | — | — | — | — | — | — | — | ![]() |
OPTIMIZATION | — | ![]() | — | — | — | — | — | — |
OPTIMIZE | — | ![]() | — | ![]() | — | — | — | — |
OPTIMIZER_COSTS | — | — | — | ![]() | — | — | — | — |
OPTION | — | — | — | ![]() | ![]() | — | ![]() | ![]() |
OPTIONALLY | — | — | — | ![]() | — | — | — | — |
OR | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ORDER | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
ORDINALITY | — | — | — | — | — | — | — | ![]() |
ORGANIZATION | — | ![]() | — | — | — | — | — | — |
OUT | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
OUTER | ![]() | ![]() | — | ![]() | — | ![]() | ![]() | ![]() |
OUTFILE | — | — | — | ![]() | — | — | — | — |
OUTPUT | — | — | — | — | — | — | — | ![]() |
OVER | ![]() | — | — | ![]() | — | — | ![]() | ![]() |
OVERLAPS | ![]() | — | ![]() | — | — | ![]() | — | ![]() |
OVERLAY | ![]() | — | — | — | — | — | — | — |
OVERRIDE | — | — | — | — | — | — | — | ![]() |
PACKAGE | — | ![]() | — | — | — | — | — | — |
PAD | — | — | — | — | — | — | — | ![]() |
PADDED | — | ![]() | — | — | — | — | — | — |
PARAMETER | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
PARAMETERS | — | — | — | — | — | — | — | ![]() |
PART | — | ![]() | — | — | — | — | — | — |
PARTIAL | — | — | — | — | — | — | — | ![]() |
PARTITION | ![]() | ![]() | — | ![]() | — | — | — | — |
PARTITIONED | — | ![]() | — | — | — | — | — | — |
PARTITIONING | — | ![]() | — | — | — | — | — | — |
PASSWORD | — | — | — | — | — | — | — | ![]() |
PATH | — | ![]() | — | — | — | — | — | ![]() |
PATTERN | ![]() | — | — | — | — | — | — | — |
PCTFREE | — | — | — | — | ![]() | — | — | — |
PER | ![]() | — | — | — | — | — | — | — |
PERCENT | ![]() | — | — | — | — | — | ![]() | ![]() |
PERCENTILE_CONT | ![]() | — | — | — | — | — | — | — |
PERCENTILE_DISC | ![]() | — | — | — | — | — | — | — |
PERCENT_RANK | ![]() | — | — | ![]() | — | — | — | ![]() |
PERIOD | ![]() | ![]() | — | — | — | — | — | — |
PERM | — | — | — | — | — | — | — | ![]() |
PERMANENT | — | — | — | — | — | — | — | ![]() |
PIECESIZE | — | ![]() | — | — | — | — | — | — |
PIVOT | — | — | — | — | — | — | ![]() | — |
PLACING | — | — | — | — | — | ![]() | — | — |
PLAN | — | ![]() | — | — | — | — | ![]() | — |
PORTION | ![]() | — | — | — | — | — | — | — |
POSITION | ![]() | — | — | — | — | — | — | ![]() |
POSITION_REGEX | ![]() | — | — | — | — | — | — | — |
POSTFIX | — | — | — | — | — | — | — | ![]() |
POWER | ![]() | — | — | — | — | — | — | — |
PRECEDES | ![]() | — | — | — | — | — | — | — |
PRECISION | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
PREFIX | — | — | — | — | — | — | — | ![]() |
PREORDER | — | — | — | — | — | — | — | ![]() |
PREPARE | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
PRESERVE | — | — | — | — | — | — | — | ![]() |
PREVVAL | — | ![]() | — | — | — | — | — | — |
PRIMARY | ![]() | — | ![]() | ![]() | — | ![]() | ![]() | ![]() |
— | — | — | — | — | — | ![]() | — | |
PRIOR | — | ![]() | — | — | ![]() | — | — | ![]() |
PRIQTY | — | ![]() | — | — | — | — | — | — |
PRIVATE | — | — | — | — | — | — | — | ![]() |
PRIVILEGES | — | ![]() | — | — | — | — | — | ![]() |
PROC | — | — | — | — | — | — | ![]() | — |
PROCEDURE | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
PROFILE | — | — | — | — | — | — | — | ![]() |
PROGRAM | — | ![]() | — | — | — | — | — | — |
PROPORTIONAL | — | — | — | — | — | — | — | ![]() |
PROTECTION | — | — | — | — | — | — | — | ![]() |
PSID | — | ![]() | — | — | — | — | — | — |
PTF | ![]() | — | — | — | — | — | — | — |
PUBLIC | — | ![]() | — | — | ![]() | — | ![]() | ![]() |
PURGE | — | — | — | ![]() | — | — | — | — |
QUALIFIED | — | — | — | — | — | — | — | ![]() |
QUALIFY | — | — | — | — | — | — | — | ![]() |
QUANTILE | — | — | — | — | — | — | — | ![]() |
QUERY | — | ![]() | — | — | — | — | — | — |
QUERYNO | — | ![]() | — | — | — | — | — | — |
RADIANS | — | — | — | — | — | — | — | ![]() |
RAISERROR | — | — | — | — | — | — | ![]() | — |
RANDOM | — | — | — | — | — | — | — | ![]() |
RANGE | ![]() | — | — | ![]() | — | — | — | — |
RANGE_N | — | — | — | — | — | — | — | ![]() |
RANK | ![]() | — | — | ![]() | — | — | — | ![]() |
RAW | — | — | — | — | ![]() | — | — | — |
READ | — | — | — | ![]() | — | — | ![]() | ![]() |
READS | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
READTEXT | — | — | — | — | — | — | ![]() | — |
READ_WRITE | — | — | — | ![]() | — | — | — | — |
REAL | ![]() | — | — | ![]() | — | — | — | ![]() |
RECONFIGURE | — | — | — | — | — | — | ![]() | — |
RECURSIVE | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
REF | ![]() | — | — | — | — | — | — | ![]() |
REFERENCES | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
REFERENCING | ![]() | — | ![]() | — | — | — | — | ![]() |
REFRESH | — | ![]() | — | — | — | — | — | — |
REGEXP | — | — | — | ![]() | — | — | — | — |
REGR_AVGX | ![]() | — | — | — | — | — | — | ![]() |
REGR_AVGY | ![]() | — | — | — | — | — | — | ![]() |
REGR_COUNT | ![]() | — | — | — | — | — | — | ![]() |
REGR_INTERCEPT | ![]() | — | — | — | — | — | — | ![]() |
REGR_R2 | ![]() | — | — | — | — | — | — | ![]() |
REGR_SLOPE | ![]() | — | — | — | — | — | — | ![]() |
REGR_SXX | ![]() | — | — | — | — | — | — | ![]() |
REGR_SXY | ![]() | — | — | — | — | — | — | ![]() |
REGR_SYY | ![]() | — | — | — | — | — | — | ![]() |
RELATIVE | — | — | — | — | — | — | — | ![]() |
RELEASE | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
RENAME | — | ![]() | — | ![]() | ![]() | — | — | ![]() |
REPEAT | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
REPLACE | — | — | — | ![]() | — | — | — | ![]() |
REPLICATION | — | — | — | — | — | — | ![]() | ![]() |
REPOVERRIDE | — | — | — | — | — | — | — | ![]() |
REQUEST | — | — | — | — | — | — | — | ![]() |
REQUIRE | — | — | — | ![]() | — | — | — | — |
RESIGNAL | ![]() | ![]() | ![]() | ![]() | — | — | — | — |
RESOURCE | — | — | — | — | ![]() | — | — | — |
RESTART | — | — | — | — | — | — | — | ![]() |
RESTORE | — | — | — | — | — | — | ![]() | ![]() |
RESTRICT | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
RESULT | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
RESULT_SET_LOCATOR | — | ![]() | — | — | — | — | — | — |
RESUME | — | — | — | — | — | — | — | ![]() |
RET | — | — | — | — | — | — | — | ![]() |
RETRIEVE | — | — | — | — | — | — | — | ![]() |
RETURN | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
RETURNING | — | — | — | — | — | ![]() | — | — |
RETURNS | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
REVALIDATE | — | — | — | — | — | — | — | ![]() |
REVERT | — | — | — | — | — | — | ![]() | — |
REVOKE | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
RIGHT | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
RIGHTS | — | — | — | — | — | — | — | ![]() |
RLIKE | — | — | — | ![]() | — | — | — | — |
ROLE | — | ![]() | — | — | — | — | — | ![]() |
ROLLBACK | ![]() | ![]() | ![]() | — | — | — | ![]() | ![]() |
ROLLFORWARD | — | — | — | — | — | — | — | ![]() |
ROLLUP | ![]() | ![]() | — | — | — | — | — | ![]() |
ROUND_CEILING | — | ![]() | — | — | — | — | — | — |
ROUND_DOWN | — | ![]() | — | — | — | — | — | — |
ROUND_FLOOR | — | ![]() | — | — | — | — | — | — |
ROUND_HALF_DOWN | — | ![]() | — | — | — | — | — | — |
ROUND_HALF_EVEN | — | ![]() | — | — | — | — | — | — |
ROUND_HALF_UP | — | ![]() | — | — | — | — | — | — |
ROUND_UP | — | ![]() | — | — | — | — | — | — |
ROUTINE | — | — | — | — | — | — | — | ![]() |
ROW | ![]() | ![]() | ![]() | ![]() | ![]() | — | — | ![]() |
ROWCOUNT | — | — | — | — | — | — | ![]() | — |
ROWGUIDCOL | — | — | — | — | — | — | ![]() | — |
ROWID | — | — | — | — | ![]() | — | — | ![]() |
ROWNUM | — | — | — | — | ![]() | — | — | — |
ROWS | ![]() | — | ![]() | ![]() | ![]() | — | — | ![]() |
ROWSET | — | ![]() | — | — | — | — | — | — |
ROW_NUMBER | ![]() | — | — | ![]() | — | — | — | ![]() |
RULE | — | — | — | — | — | — | ![]() | — |
RUN | — | ![]() | — | — | — | — | — | — |
RUNNING | ![]() | — | — | — | — | — | — | — |
SAMPLE | — | — | — | — | — | — | — | ![]() |
SAMPLEID | — | — | — | — | — | — | — | ![]() |
SAVE | — | — | — | — | — | — | ![]() | — |
SAVEPOINT | ![]() | ![]() | — | — | — | — | — | ![]() |
SCHEMA | — | ![]() | — | ![]() | — | — | ![]() | ![]() |
SCHEMAS | — | — | — | ![]() | — | — | — | — |
SCOPE | ![]() | — | — | — | — | — | — | ![]() |
SCRATCHPAD | — | ![]() | — | — | — | — | — | — |
SCROLL | ![]() | — | ![]() | — | — | — | — | ![]() |
SEARCH | ![]() | — | — | — | — | — | — | ![]() |
SECOND | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
SECONDS | — | ![]() | — | — | — | — | — | — |
SECOND_MICROSECOND | — | — | — | ![]() | — | — | — | — |
SECQTY | — | ![]() | — | — | — | — | — | — |
SECTION | — | — | — | — | — | — | — | ![]() |
SECURITY | — | ![]() | — | — | — | — | — | — |
SECURITYAUDIT | — | — | — | — | — | — | ![]() | — |
SEEK | ![]() | — | — | — | — | — | — | — |
SEL | — | — | — | — | — | — | — | ![]() |
SELECT | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
SEMANTICKEYPHRASETABLE | — | — | — | — | — | — | ![]() | — |
SEMANTICSIMILARITYDETAILSTABLE | — | — | — | — | — | — | ![]() | — |
SEMANTICSIMILARITYTABLE | — | — | — | — | — | — | ![]() | — |
SENSITIVE | ![]() | ![]() | — | ![]() | — | — | — | — |
SEPARATOR | — | — | — | ![]() | — | — | — | — |
SEQUENCE | — | ![]() | — | — | — | — | — | ![]() |
SESSION | — | — | — | — | ![]() | — | — | ![]() |
SESSION_USER | ![]() | ![]() | ![]() | — | — | ![]() | ![]() | ![]() |
SET | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
SETRESRATE | — | — | — | — | — | — | — | ![]() |
SETS | — | — | — | — | — | — | — | ![]() |
SETSESSRATE | — | — | — | — | — | — | — | ![]() |
SETUSER | — | — | — | — | — | — | ![]() | — |
SHARE | — | — | — | — | ![]() | — | — | — |
SHOW | ![]() | — | — | ![]() | — | — | — | ![]() |
SHUTDOWN | — | — | — | — | — | — | ![]() | — |
SIGNAL | ![]() | ![]() | ![]() | ![]() | — | — | — | — |
SIMILAR | ![]() | — | — | — | — | ![]() | — | — |
SIMPLE | — | ![]() | — | — | — | — | — | — |
SIN | ![]() | — | — | — | — | — | — | ![]() |
SINH | ![]() | — | — | — | — | — | — | ![]() |
SIZE | — | — | — | — | ![]() | — | — | ![]() |
SKEW | — | — | — | — | — | — | — | ![]() |
SKIP | ![]() | — | — | — | — | — | — | — |
SMALLINT | ![]() | — | — | ![]() | ![]() | — | — | ![]() |
SOME | ![]() | ![]() | ![]() | — | — | ![]() | ![]() | ![]() |
SOUNDEX | — | — | — | — | — | — | — | ![]() |
SOURCE | — | ![]() | — | — | — | — | — | — |
SPACE | — | — | — | — | — | — | — | ![]() |
SPATIAL | — | — | — | ![]() | — | — | — | — |
SPECIFIC | ![]() | ![]() | ![]() | ![]() | — | — | — | ![]() |
SPECIFICTYPE | ![]() | — | — | — | — | — | — | ![]() |
SPOOL | — | — | — | — | — | — | — | ![]() |
SQL | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
SQLEXCEPTION | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
SQLSTATE | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
SQLTEXT | — | — | — | — | — | — | — | ![]() |
SQLWARNING | ![]() | — | ![]() | ![]() | — | — | — | ![]() |
SQL_BIG_RESULT | — | — | — | ![]() | — | — | — | — |
SQL_CALC_FOUND_ROWS | — | — | — | ![]() | — | — | — | — |
SQL_SMALL_RESULT | — | — | — | ![]() | — | — | — | — |
SQRT | ![]() | — | — | — | — | — | — | ![]() |
SS | — | — | — | — | — | — | — | ![]() |
SSL | — | — | — | ![]() | — | — | — | — |
STANDARD | — | ![]() | — | — | — | — | — | — |
START | ![]() | — | ![]() | — | ![]() | — | — | ![]() |
STARTING | — | — | — | ![]() | — | — | — | — |
STARTUP | — | — | — | — | — | — | — | ![]() |
STATE | — | — | — | — | — | — | — | ![]() |
STATEMENT | — | ![]() | — | — | — | — | — | ![]() |
STATIC | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
STATISTICS | — | — | — | — | — | — | ![]() | ![]() |
STAY | — | ![]() | — | — | — | — | — | — |
STDDEV_POP | ![]() | — | — | — | — | — | — | ![]() |
STDDEV_SAMP | ![]() | — | — | — | — | — | — | ![]() |
STEPINFO | — | — | — | — | — | — | — | ![]() |
STOGROUP | — | ![]() | — | — | — | — | — | — |
STORED | — | — | — | ![]() | — | — | — | — |
STORES | — | ![]() | — | — | — | — | — | — |
STRAIGHT_JOIN | — | — | — | ![]() | — | — | — | — |
STRING_CS | — | — | — | — | — | — | — | ![]() |
STRUCTURE | — | — | — | — | — | — | — | ![]() |
STYLE | — | ![]() | — | — | — | — | — | — |
SUBMULTISET | ![]() | — | — | — | — | — | — | — |
SUBSCRIBER | — | — | — | — | — | — | — | ![]() |
SUBSET | ![]() | — | — | — | — | — | — | — |
SUBSTR | — | — | — | — | — | — | — | ![]() |
SUBSTRING | ![]() | — | — | — | — | — | — | ![]() |
SUBSTRING_REGEX | ![]() | — | — | — | — | — | — | — |
SUCCEEDS | ![]() | — | — | — | — | — | — | — |
SUCCESSFUL | — | — | — | — | ![]() | — | — | — |
SUM | ![]() | — | — | — | — | — | — | ![]() |
SUMMARY | — | ![]() | — | — | — | — | — | ![]() |
SUSPEND | — | — | — | — | — | — | — | ![]() |
SYMMETRIC | ![]() | — | ![]() | — | — | ![]() | — | — |
SYNONYM | — | ![]() | — | — | ![]() | — | — | — |
SYSDATE | — | ![]() | — | — | ![]() | — | — | — |
SYSTEM | ![]() | ![]() | — | ![]() | — | — | — | — |
SYSTEM_TIME | ![]() | — | — | — | — | — | — | — |
SYSTEM_USER | ![]() | — | ![]() | — | — | — | ![]() | ![]() |
SYSTIMESTAMP | — | ![]() | — | — | — | — | — | — |
TABLE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
TABLESAMPLE | ![]() | — | — | — | — | ![]() | ![]() | — |
TABLESPACE | — | ![]() | — | — | — | — | — | — |
TAN | ![]() | — | — | — | — | — | — | ![]() |
TANH | ![]() | — | — | — | — | — | — | ![]() |
TBL_CS | — | — | — | — | — | — | — | ![]() |
TEMPORARY | — | — | — | — | — | — | — | ![]() |
TERMINATE | — | — | — | — | — | — | — | ![]() |
TERMINATED | — | — | — | ![]() | — | — | — | — |
TEXTSIZE | — | — | — | — | — | — | ![]() | — |
THAN | — | — | — | — | — | — | — | ![]() |
THEN | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
THRESHOLD | — | — | — | — | — | — | — | ![]() |
TIME | ![]() | — | — | — | — | — | — | ![]() |
TIMESTAMP | ![]() | — | — | — | — | — | — | ![]() |
TIMEZONE_HOUR | ![]() | — | ![]() | — | — | — | — | ![]() |
TIMEZONE_MINUTE | ![]() | — | ![]() | — | — | — | — | ![]() |
TINYBLOB | — | — | — | ![]() | — | — | — | — |
TINYINT | — | — | — | ![]() | — | — | — | — |
TINYTEXT | — | — | — | ![]() | — | — | — | — |
TITLE | — | — | — | — | — | — | — | ![]() |
TO | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
TOP | — | — | — | — | — | — | ![]() | — |
TRACE | — | — | — | — | — | — | — | ![]() |
TRAILING | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
TRAN | — | — | — | — | — | — | ![]() | — |
TRANSACTION | — | — | — | — | — | — | ![]() | ![]() |
TRANSLATE | ![]() | — | — | — | — | — | — | ![]() |
TRANSLATE_CHK | — | — | — | — | — | — | — | ![]() |
TRANSLATE_REGEX | ![]() | — | — | — | — | — | — | — |
TRANSLATION | ![]() | — | — | — | — | — | — | ![]() |
TREAT | ![]() | — | ![]() | — | — | — | — | ![]() |
TRIGGER | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
TRIM | ![]() | — | — | — | — | — | — | ![]() |
TRIM_ARRAY | ![]() | — | — | — | — | — | — | — |
TRUE | ![]() | — | ![]() | ![]() | — | ![]() | — | ![]() |
TRUNCATE | ![]() | ![]() | — | — | — | — | ![]() | — |
TRY_CONVERT | — | — | — | — | — | — | ![]() | — |
TSEQUAL | — | — | — | — | — | — | ![]() | — |
TYPE | — | ![]() | — | — | — | — | — | ![]() |
UC | — | — | — | — | — | — | — | ![]() |
UESCAPE | ![]() | — | — | — | — | — | — | — |
UID | — | — | — | — | ![]() | — | — | — |
UNDEFINED | — | — | — | — | — | — | — | ![]() |
UNDER | — | — | — | — | — | — | — | ![]() |
UNDO | — | ![]() | — | ![]() | — | — | — | ![]() |
UNION | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
UNIQUE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
UNKNOWN | ![]() | — | ![]() | — | — | — | — | ![]() |
UNLOCK | — | — | — | ![]() | — | — | — | — |
UNNEST | ![]() | — | — | — | — | — | — | ![]() |
UNPIVOT | — | — | — | — | — | — | ![]() | — |
UNSIGNED | — | — | — | ![]() | — | — | — | — |
UNTIL | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
UPD | — | — | — | — | — | — | — | ![]() |
UPDATE | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
UPDATETEXT | — | — | — | — | — | — | ![]() | — |
UPPER | ![]() | — | — | — | — | — | — | ![]() |
UPPERCASE | — | — | — | — | — | — | — | ![]() |
USAGE | — | — | — | ![]() | — | — | — | ![]() |
USE | — | — | — | ![]() | — | — | ![]() | — |
USER | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() | ![]() |
USING | ![]() | ![]() | ![]() | ![]() | — | ![]() | — | ![]() |
UTC_DATE | — | — | — | ![]() | — | — | — | — |
UTC_TIME | — | — | — | ![]() | — | — | — | — |
UTC_TIMESTAMP | — | — | — | ![]() | — | — | — | — |
VALIDATE | — | — | — | — | ![]() | — | — | — |
VALIDPROC | — | ![]() | — | — | — | — | — | — |
VALUE | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
VALUES | ![]() | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() |
VALUE_OF | ![]() | — | — | — | — | — | — | — |
VARBINARY | ![]() | — | — | ![]() | — | — | — | — |
VARBYTE | — | — | — | — | — | — | — | ![]() |
VARCHAR | ![]() | — | — | ![]() | ![]() | — | — | ![]() |
VARCHAR2 | — | — | — | — | ![]() | — | — | — |
VARCHARACTER | — | — | — | ![]() | — | — | — | — |
VARGRAPHIC | — | — | — | — | — | — | — | ![]() |
VARIABLE | — | ![]() | — | — | — | — | — | ![]() |
VARIADIC | — | — | — | — | — | ![]() | — | — |
VARIANT | — | ![]() | — | — | — | — | — | — |
VARYING | ![]() | — | ![]() | ![]() | — | — | ![]() | ![]() |
VAR_POP | ![]() | — | — | — | — | — | — | ![]() |
VAR_SAMP | ![]() | — | — | — | — | — | — | ![]() |
VCAT | — | ![]() | — | — | — | — | — | — |
VERBOSE | — | — | — | — | — | ![]() | — | — |
VERSIONING | ![]() | ![]() | — | — | — | — | — | — |
VIEW | — | ![]() | — | — | ![]() | — | ![]() | ![]() |
VIRTUAL | — | — | — | ![]() | — | — | — | — |
VOLATILE | — | ![]() | — | — | — | — | — | ![]() |
VOLUMES | — | ![]() | — | — | — | — | — | — |
WAIT | — | — | — | — | — | — | — | ![]() |
WAITFOR | — | — | — | — | — | — | ![]() | — |
WHEN | ![]() | ![]() | ![]() | ![]() | — | ![]() | ![]() | ![]() |
WHENEVER | ![]() | ![]() | — | — | ![]() | — | — | ![]() |
WHERE | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
WHILE | ![]() | ![]() | ![]() | ![]() | — | — | ![]() | ![]() |
WIDTH_BUCKET | ![]() | — | — | — | — | — | — | ![]() |
WINDOW | ![]() | — | — | ![]() | — | ![]() | — | — |
WITH | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
WITHIN | ![]() | — | — | — | — | — | — | — |
WITHIN_GROUP | — | — | — | — | — | — | ![]() | — |
WITHOUT | ![]() | — | ![]() | — | — | — | — | ![]() |
WLM | — | ![]() | — | — | — | — | — | — |
WORK | — | — | — | — | — | — | — | ![]() |
WRITE | — | — | — | ![]() | — | — | — | ![]() |
WRITETEXT | — | — | — | — | — | — | ![]() | — |
XMLCAST | — | ![]() | — | — | — | — | — | — |
XMLEXISTS | — | ![]() | — | — | — | — | — | — |
XMLNAMESPACES | — | ![]() | — | — | — | — | — | — |
XOR | — | — | — | ![]() | — | — | — | — |
YEAR | ![]() | ![]() | ![]() | — | — | — | — | ![]() |
YEARS | — | ![]() | — | — | — | — | — | — |
YEAR_MONTH | — | — | — | ![]() | — | — | — | — |
ZEROFILL | — | — | — | ![]() | — | — | — | — |
ZEROIFNULL | — | — | — | — | — | — | — | ![]() |
ZONE | — | ![]() | — | — | — | — | — | ![]() |
References
- ISO/IEC JTC 1/SC 32 (Data management and interchange committee) (December 2016). ISO/IEC 9075-1:2016 Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) (Technical report) (5 ed.). Retrieved 23 December 2020.CS1 maint: uses authors parameter (link)
- "Reserved words". IBM Knowledge Center. IBM. Retrieved 23 December 2020.
- "Reserved Words". Mimer SQL Manuals. Mimer AB. Retrieved 23 December 2020.
- "Keywords and Reserved Words". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 23 December 2020.
- "Oracle SQL Reserved Words". SQL Language Reference. Oracle Corporation. Retrieved 23 December 2020.
- "Appendix C. SQL Key Words". PostgreSQL Documentation. PostgreSQL Global Development Group. Retrieved 23 December 2020.
- "Reserved Keywords (Transact-SQL)". Microsoft Docs – SQL Server. Microsoft. Retrieved 23 December 2020.
- "Reserved Words for Teradata". The Teradata Forum. Manta BlueSky. Retrieved 23 December 2020.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.