blob: 75db61d1112adde2e66644fb83fb815cee9d0e47 [file] [log] [blame] [view]
---
title: Keywords
sidebar_label: Keywords
---
{/*
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
*/}
This topic covers keywords in Apache Ignite 3.
Non-reserved keywords can be used as identifiers (names for tables, columns, etc.) without requiring quotation marks or special escaping. These keywords have meaning in SQL contexts but do not conflict with basic SQL grammar.
Reserved keywords must be wrapped in double quotes to be used as identifiers, for example, table names or column names. If a reserved word is used as an identifier without being quoted, a syntax error will happen.
```sql
-- Valid keyword usage.
SELECT 1 AS "ABS";
-- The query below would cause an error.
-- SELECT 1 AS ABS;
```
The following list shows the keywords in Apache Ignite 3.0.0.
| Keyword | Apache Ignite 3 | SQL 2016 |
|---|---|---|
| A | | |
| ABS | Reserved | Reserved |
| ABSENT | | Reserved |
| ABSOLUTE | | |
| ACTION | | |
| ADA | | |
| ADD | | |
| ADMIN | | |
| AFTER | | |
| ALGORITHM | | |
| ALL | Reserved | Reserved |
| ALLOCATE | | Reserved |
| ALLOW | | |
| ALTER | Reserved | Reserved |
| ALWAYS | | |
| AND | Reserved | Reserved |
| ANY | Reserved | Reserved |
| APPLY | | |
| ARE | | Reserved |
| ARRAY | Reserved | Reserved |
| ARRAY_AGG | | Reserved |
| ARRAY_CONCAT_AGG | | |
| ARRAY_MAX_CARDINALITY | Reserved | Reserved |
| AS | Reserved | Reserved |
| ASC | | Reserved |
| ASENSITIVE | | Reserved |
| ASOF | Reserved | |
| ASSERTION | | |
| ASSIGNMENT | | |
| ASYMMETRIC | Reserved | Reserved |
| AT | | Reserved |
| ATOMIC | | Reserved |
| ATTRIBUTE | | |
| ATTRIBUTES | | |
| AUTHORIZATION | | Reserved |
| AUTO | | |
| AVG | Reserved | Reserved |
| BEFORE | | |
| BEGIN | | Reserved |
| BEGIN_FRAME | | Reserved |
| BEGIN_PARTITION | | Reserved |
| BERNOULLI | | |
| BETWEEN | Reserved | Reserved |
| BIGINT | | Reserved |
| BINARY | | Reserved |
| BIT | | |
| BLOB | | Reserved |
| BOOLEAN | | Reserved |
| BOTH | Reserved | Reserved |
| BREADTH | | |
| BY | Reserved | Reserved |
| C | | |
| CACHE | Reserved | |
| CALL | Reserved | Reserved |
| CALLED | | Reserved |
| CARDINALITY | Reserved | Reserved |
| CASCADE | | Reserved |
| CASCADED | | Reserved |
| CASE | Reserved | Reserved |
| CAST | Reserved | Reserved |
| CATALOG | | |
| CATALOG_NAME | | |
| CEIL | | |
| CEILING | Reserved | Reserved |
| CENTURY | | |
| CHAIN | | |
| CHAR | Reserved | Reserved |
| CHARACTER | Reserved | Reserved |
| CHARACTERISTICS | | |
| CHARACTERS | | |
| CHARACTER_LENGTH | Reserved | Reserved |
| CHARACTER_SET_CATALOG | | |
| CHARACTER_SET_NAME | | |
| CHARACTER_SET_SCHEMA | | |
| CHAR_LENGTH | Reserved | Reserved |
| CHECK | | Reserved |
| CLASSIFIER | | Reserved |
| CLASS_ORIGIN | | |
| CLOB | | Reserved |
| CLOSE | | Reserved |
| COALESCE | Reserved | Reserved |
| COBOL | | |
| COLLATE | | Reserved |
| COLLATION | | |
| COLLATION_CATALOG | | |
| COLLATION_NAME | | |
| COLLATION_SCHEMA | | |
| COLLECT | Reserved | Reserved |
| COLOCATE | | |
| COLUMN | Reserved | Reserved |
| COLUMN_NAME | | |
| COMMAND_FUNCTION | | |
| COMMAND_FUNCTION_CODE | | |
| COMMIT | | Reserved |
| COMMITTED | | |
| COMPUTE | | |
| CONDITION | | Reserved |
| CONDITIONAL | | Reserved |
| CONDITION_NUMBER | | |
| CONNECT | | Reserved |
| CONNECTION | | |
| CONNECTION_NAME | | |
| CONSISTENCY | | |
| CONSTRAINT | Reserved | Reserved |
| CONSTRAINTS | | |
| CONSTRAINT_CATALOG | | |
| CONSTRAINT_NAME | | |
| CONSTRAINT_SCHEMA | | |
| CONSTRUCTOR | | |
| CONTAINS | | Reserved |
| CONTAINS_SUBSTR | | |
| CONTINUE | | |
| CONVERT | Reserved | Reserved |
| CORR | | Reserved |
| CORRESPONDING | | Reserved |
| COUNT | Reserved | Reserved |
| COVAR_POP | Reserved | Reserved |
| COVAR_SAMP | Reserved | Reserved |
| CREATE | Reserved | Reserved |
| CROSS | Reserved | Reserved |
| CUBE | Reserved | Reserved |
| CUME_DIST | Reserved | Reserved |
| CURRENT | Reserved | Reserved |
| CURRENT_CATALOG | Reserved | Reserved |
| CURRENT_DATE | Reserved | Reserved |
| CURRENT_DEFAULT_TRANSFORM_GROUP | Reserved | Reserved |
| CURRENT_PATH | Reserved | Reserved |
| CURRENT_ROLE | Reserved | Reserved |
| CURRENT_ROW | Reserved | Reserved |
| CURRENT_SCHEMA | Reserved | Reserved |
| CURRENT_TIME | Reserved | Reserved |
| CURRENT_TIMESTAMP | Reserved | Reserved |
| CURRENT_TRANSFORM_GROUP_FOR_TYPE | Reserved | Reserved |
| CURRENT_USER | Reserved | Reserved |
| CURSOR | | Reserved |
| CURSOR_NAME | | |
| CYCLE | | Reserved |
| DATA | | |
| DATABASE | | |
| DATALINK | | Reserved |
| DATE | Reserved | Reserved |
| DATETIME | Reserved | |
| DATETIME_DIFF | | |
| DATETIME_INTERVAL_CODE | | |
| DATETIME_INTERVAL_PRECISION | | |
| DATETIME_TRUNC | | |
| DATE_DIFF | | |
| DATE_TRUNC | | |
| DAY | | Reserved |
| DAYOFWEEK | | |
| DAYOFYEAR | | |
| DAYS | | |
| DEALLOCATE | | Reserved |
| DEC | | Reserved |
| DECADE | | |
| DECFLOAT | | Reserved |
| DECIMAL | Reserved | Reserved |
| DECLARE | | Reserved |
| DEFAULT | Reserved | Reserved |
| DEFAULTS | | |
| DEFERRABLE | | |
| DEFERRED | | |
| DEFINE | | Reserved |
| DEFINED | | |
| DEFINER | | |
| DEGREE | | |
| DELETE | Reserved | Reserved |
| DENSE_RANK | Reserved | Reserved |
| DEPTH | | |
| DEREF | | Reserved |
| DERIVED | | |
| DESC | | |
| DESCRIBE | Reserved | Reserved |
| DESCRIPTION | | |
| DESCRIPTOR | | |
| DETERMINISTIC | | |
| DIAGNOSTICS | | |
| DISALLOW | | |
| DISCONNECT | | Reserved |
| DISPATCH | | |
| DISTINCT | Reserved | Reserved |
| DISTRIBUTION | | |
| DLNEWCOPY | | Reserved |
| DLPREVIOUSCOPY | | Reserved |
| DLURLCOMPLETE | | Reserved |
| DLURLCOMPLETEONLY | | Reserved |
| DLURLCOMPLETEWRITE | | Reserved |
| DLURLPATH | | Reserved |
| DLURLPATHONLY | | Reserved |
| DLURLPATHWRITE | | Reserved |
| DLURLSCHEME | | Reserved |
| DLURLSERVER | | Reserved |
| DLVALUE | | Reserved |
| DOMAIN | | |
| DOT | | |
| DOUBLE | | Reserved |
| DOW | | |
| DOWN | | |
| DOY | | |
| DROP | Reserved | Reserved |
| DYNAMIC | | Reserved |
| DYNAMIC_FUNCTION | | |
| DYNAMIC_FUNCTION_CODE | | |
| EACH | | Reserved |
| ELEMENT | Reserved | Reserved |
| ELSE | Reserved | Reserved |
| EMPTY | | Reserved |
| ENCODING | | |
| END | | Reserved |
| END-EXEC | | Reserved |
| END_FRAME | | Reserved |
| END_PARTITION | | Reserved |
| ENGINE | | |
| EPOCH | | |
| EQUALS | | Reserved |
| ERROR | | |
| ESCAPE | | Reserved |
| EVERY | Reserved | Reserved |
| EXCEPT | Reserved | Reserved |
| EXCEPTION | | |
| EXCLUDE | | |
| EXCLUDING | | |
| EXEC | | Reserved |
| EXECUTE | | Reserved |
| EXISTS | Reserved | Reserved |
| EXP | Reserved | Reserved |
| EXPLAIN | Reserved | |
| EXTEND | Reserved | |
| EXTERNAL | | Reserved |
| EXTRACT | Reserved | Reserved |
| FALSE | Reserved | Reserved |
| FETCH | Reserved | Reserved |
| FILTER | Reserved | Reserved |
| FINAL | | |
| FIRST | | |
| FIRST_VALUE | Reserved | Reserved |
| FLOAT | | Reserved |
| FLOOR | Reserved | Reserved |
| FOLLOWING | | |
| FOR | Reserved | Reserved |
| FOREIGN | | Reserved |
| FORMAT | | |
| FORTRAN | | |
| FOUND | | |
| FRAC_SECOND | | |
| FRAME_ROW | | Reserved |
| FREE | | Reserved |
| FRIDAY | Reserved | |
| FROM | Reserved | Reserved |
| FULL | Reserved | Reserved |
| FUNCTION | | Reserved |
| FUSION | Reserved | Reserved |
| G | | |
| GENERAL | | |
| GENERATED | | |
| GEOMETRY | | |
| GET | | Reserved |
| GLOBAL | | Reserved |
| GO | | |
| GOTO | | |
| GRANT | | Reserved |
| GRANTED | | |
| GROUP | Reserved | Reserved |
| GROUPING | Reserved | Reserved |
| GROUPS | | Reserved |
| GROUP_CONCAT | | |
| HASH | | |
| HAVING | Reserved | Reserved |
| HIERARCHY | | |
| HOLD | | Reserved |
| HOP | | |
| HOUR | Reserved | Reserved |
| HOURS | | |
| IDENTIFIED | Reserved | |
| IDENTITY | | Reserved |
| IF | Reserved | |
| IGNORE | | |
| ILIKE | | |
| IMMEDIATE | | |
| IMMEDIATELY | | |
| IMPLEMENTATION | | |
| IMPORT | | Reserved |
| IN | Reserved | Reserved |
| INCLUDE | | |
| INCLUDING | | |
| INCREMENT | | |
| INDEX | Reserved | |
| INDICATOR | | Reserved |
| INITIAL | | Reserved |
| INITIALLY | | Reserved |
| INNER | Reserved | Reserved |
| INOUT | | Reserved |
| INPUT | | |
| INSENSITIVE | | Reserved |
| INSERT | Reserved | Reserved |
| INSTANCE | | |
| INSTANTIABLE | | |
| INT | | Reserved |
| INTEGER | | Reserved |
| INTERSECT | Reserved | Reserved |
| INTERSECTION | Reserved | Reserved |
| INTERVAL | Reserved | Reserved |
| INTO | Reserved | Reserved |
| INVOKER | | |
| IS | Reserved | Reserved |
| ISODOW | | |
| ISOLATION | | |
| ISOYEAR | | |
| JAVA | | |
| JOIN | Reserved | Reserved |
| JSON | | Reserved |
| JSON_ARRAY | | Reserved |
| JSON_ARRAYAGG | | Reserved |
| JSON_EXISTS | | Reserved |
| JSON_OBJECT | | Reserved |
| JSON_OBJECTAGG | | Reserved |
| JSON_QUERY | | Reserved |
| JSON_SCOPE | Reserved | |
| JSON_TABLE | | Reserved |
| JSON_TABLE_PRIMITIVE | | Reserved |
| JSON_VALUE | | Reserved |
| K | | |
| KEY | | |
| KEY_MEMBER | | |
| KEY_TYPE | | |
| KILL | | |
| LABEL | | |
| LAG | Reserved | Reserved |
| LANGUAGE | | Reserved |
| LARGE | | Reserved |
| LAST | | |
| LAST_VALUE | Reserved | Reserved |
| LATERAL | | Reserved |
| LEAD | Reserved | Reserved |
| LEADING | Reserved | Reserved |
| LEFT | Reserved | Reserved |
| LENGTH | | |
| LEVEL | | |
| LIBRARY | | |
| LIKE | Reserved | Reserved |
| LIKE_REGEX | | Reserved |
| LIMIT | Reserved | |
| LISTAGG | | Reserved |
| LN | Reserved | Reserved |
| LOCAL | | Reserved |
| LOCALTIME | Reserved | Reserved |
| LOCALTIMESTAMP | Reserved | Reserved |
| LOCATOR | | |
| LOWER | Reserved | Reserved |
| M | | |
| MAP | | |
| MAPPING | | |
| MATCH | | Reserved |
| MATCHED | | |
| MATCHES | | Reserved |
| MATCH_CONDITION | Reserved | |
| MATCH_NUMBER | | Reserved |
| MATCH_RECOGNIZE | Reserved | Reserved |
| MAX | Reserved | Reserved |
| MAXVALUE | | |
| MEASURE | Reserved | |
| MEASURES | | |
| MEMBER | | Reserved |
| MERGE | Reserved | Reserved |
| MESSAGE_LENGTH | | |
| MESSAGE_OCTET_LENGTH | | |
| MESSAGE_TEXT | | |
| METHOD | | Reserved |
| MICROSECOND | | |
| MILLENNIUM | | |
| MILLISECOND | | |
| MIN | Reserved | Reserved |
| MINUS | Reserved | |
| MINUTE | Reserved | Reserved |
| MINUTES | | |
| MINVALUE | | |
| MOD | Reserved | Reserved |
| MODE | | |
| MODIFIES | | Reserved |
| MODULE | | Reserved |
| MONDAY | Reserved | |
| MONTH | Reserved | Reserved |
| MONTHS | | |
| MORE | | |
| MULTISET | Reserved | Reserved |
| MUMPS | | |
| NAME | | |
| NAMES | | |
| NANOSECOND | | |
| NATIONAL | | Reserved |
| NATURAL | Reserved | Reserved |
| NCHAR | | Reserved |
| NCLOB | | Reserved |
| NESTING | | |
| NEW | Reserved | Reserved |
| NEXT | Reserved | |
| NO | | Reserved |
| NODES | | |
| NONE | | Reserved |
| NORMALIZE | | Reserved |
| NORMALIZED | | |
| NOT | Reserved | Reserved |
| NTH_VALUE | Reserved | Reserved |
| NTILE | Reserved | Reserved |
| NULL | Reserved | Reserved |
| NULLABLE | | |
| NULLIF | Reserved | Reserved |
| NULLS | | |
| NUMBER | | |
| NUMERIC | | Reserved |
| OBJECT | | |
| OCCURRENCES_REGEX | | Reserved |
| OCTET_LENGTH | Reserved | Reserved |
| OCTETS | | |
| OF | | Reserved |
| OFF | | |
| OFFSET | Reserved | |
| OLD | | Reserved |
| OMIT | | Reserved |
| ON | Reserved | Reserved |
| ONE | | Reserved |
| ONLY | | Reserved |
| OPEN | | Reserved |
| OPTION | | |
| OPTIONS | | |
| OR | Reserved | Reserved |
| ORDER | Reserved | Reserved |
| ORDERING | | |
| ORDINAL | | |
| ORDINALITY | | |
| OTHERS | | |
| OUT | | Reserved |
| OUTER | Reserved | Reserved |
| OUTPUT | | |
| OVER | Reserved | Reserved |
| OVERLAPS | | Reserved |
| OVERLAY | | Reserved |
| OVERRIDING | | |
| PAD | | |
| PARAMETER | | Reserved |
| PARAMETER_MODE | | |
| PARAMETER_NAME | | |
| PARAMETER_ORDINAL_POSITION | | |
| PARAMETER_SPECIFIC_CATALOG | | |
| PARAMETER_SPECIFIC_NAME | | |
| PARAMETER_SPECIFIC_SCHEMA | | |
| PARTIAL | | |
| PARTITION | Reserved | Reserved |
| PARTITIONS | | |
| PASCAL | | |
| PASSING | | |
| PASSTHROUGH | | |
| PAST | | |
| PATH | | |
| PATTERN | | Reserved |
| PER | | Reserved |
| PERCENT | | Reserved |
| PERCENTILE_CONT | Reserved | Reserved |
| PERCENTILE_DISC | Reserved | Reserved |
| PERCENT_RANK | Reserved | Reserved |
| PERIOD | Reserved | Reserved |
| PERMUTE | Reserved | |
| PIVOT | | |
| PLACING | | |
| PLAN | | |
| PLI | | |
| PORTION | | Reserved |
| POSITION | | Reserved |
| POSITION_REGEX | | Reserved |
| POWER | Reserved | Reserved |
| PRECEDES | | Reserved |
| PRECEDING | | |
| PRECISION | Reserved | Reserved |
| PREPARE | | Reserved |
| PRESERVE | | |
| PREV | | |
| PRIMARY | Reserved | Reserved |
| PRIOR | | |
| PRIVILEGES | | |
| PROCEDURE | | Reserved |
| PROFILE | | |
| PROFILES | | |
| PTF | | Reserved |
| PUBLIC | | |
| QUALIFY | Reserved | |
| QUARTER | | |
| QUARTERS | | |
| QUERY | | |
| QUORUM | | |
| RANGE | | Reserved |
| RANK | Reserved | Reserved |
| READ | | |
| READS | | Reserved |
| REAL | | Reserved |
| RECURSIVE | | Reserved |
| REF | | Reserved |
| REFERENCES | | Reserved |
| REFERENCING | | Reserved |
| REGR_AVGX | | Reserved |
| REGR_AVGY | | Reserved |
| REGR_COUNT | Reserved | Reserved |
| REGR_INTERCEPT | | Reserved |
| REGR_R2 | | Reserved |
| REGR_SLOPE | | Reserved |
| REGR_SXX | Reserved | Reserved |
| REGR_SXY | | Reserved |
| REGR_SYY | Reserved | Reserved |
| RELATIVE | | |
| RELEASE | | Reserved |
| RENAME | Reserved | |
| REPEATABLE | | |
| REPLACE | | |
| REPLICAS | | |
| RESET | Reserved | |
| RESPECT | | |
| RESTART | | |
| RESTRICT | | |
| RESULT | | Reserved |
| RETURN | | Reserved |
| RETURNED_CARDINALITY | | |
| RETURNED_LENGTH | | |
| RETURNED_OCTET_LENGTH | | |
| RETURNED_SQLSTATE | | |
| RETURNING | | |
| RETURNS | | Reserved |
| REVOKE | | Reserved |
| RIGHT | Reserved | Reserved |
| RLIKE | | |
| ROLE | | |
| ROLLBACK | | Reserved |
| ROLLUP | Reserved | Reserved |
| ROUTINE | | |
| ROUTINE_CATALOG | | |
| ROUTINE_NAME | | |
| ROUTINE_SCHEMA | | |
| ROW | Reserved | Reserved |
| ROWS | | Reserved |
| ROW_COUNT | | |
| ROW_NUMBER | Reserved | Reserved |
| RUNNING | | Reserved |
| SAFE_CAST | | |
| SAFE_OFFSET | | |
| SAFE_ORDINAL | | |
| SATURDAY | Reserved | |
| SAVEPOINT | | Reserved |
| SCALAR | | |
| SCALE | | |
| SCHEMA | | |
| SCHEMA_NAME | | |
| SCOPE | | Reserved |
| SCOPE_CATALOGS | | |
| SCOPE_NAME | | |
| SCOPE_SCHEMA | | |
| SCROLL | | Reserved |
| SEARCH | | Reserved |
| SECOND | Reserved | Reserved |
| SECONDS | | |
| SECTION | | |
| SECURITY | | |
| SEEK | | |
| SELECT | Reserved | Reserved |
| SELF | | |
| SENSITIVE | | Reserved |
| SEPARATOR | | |
| SEQUENCE | | |
| SERIALIZABLE | | |
| SERVER | | |
| SERVER_NAME | | |
| SESSION | | |
| SESSION_USER | Reserved | Reserved |
| SET | Reserved | Reserved |
| SETS | | |
| SHOW | | Reserved |
| SIMILAR | | Reserved |
| SIMPLE | | |
| SIZE | | |
| SKIP | | Reserved |
| SMALLINT | | Reserved |
| SOME | Reserved | Reserved |
| SORTED | | |
| SOURCE | | |
| SPACE | | |
| SPECIFIC | Reserved | Reserved |
| SPECIFICTYPE | | Reserved |
| SPECIFIC_NAME | | |
| SQL | | Reserved |
| SQLEXCEPTION | | Reserved |
| SQLSTATE | | Reserved |
| SQLWARNING | | Reserved |
| SQL_BIGINT | | |
| SQL_BINARY | | |
| SQL_BIT | | |
| SQL_BLOB | | |
| SQL_BOOLEAN | | |
| SQL_CHAR | | |
| SQL_CLOB | | |
| SQL_DATE | | |
| SQL_DECIMAL | | |
| SQL_DOUBLE | | |
| SQL_FLOAT | | |
| SQL_INTEGER | | |
| SQL_INTERVAL_DAY | | |
| SQL_INTERVAL_DAY_TO_HOUR | | |
| SQL_INTERVAL_DAY_TO_MINUTE | | |
| SQL_INTERVAL_DAY_TO_SECOND | | |
| SQL_INTERVAL_HOUR | | |
| SQL_INTERVAL_HOUR_TO_MINUTE | | |
| SQL_INTERVAL_HOUR_TO_SECOND | | |
| SQL_INTERVAL_MINUTE | | |
| SQL_INTERVAL_MINUTE_TO_SECOND | | |
| SQL_INTERVAL_MONTH | | |
| SQL_INTERVAL_SECOND | | |
| SQL_INTERVAL_YEAR | | |
| SQL_INTERVAL_YEAR_TO_MONTH | | |
| SQL_LONGVARBINARY | | |
| SQL_LONGVARCHAR | | |
| SQL_LONGVARNCHAR | | |
| SQL_NCHAR | | |
| SQL_NCLOB | | |
| SQL_NUMERIC | | |
| SQL_NVARCHAR | | |
| SQL_REAL | | |
| SQL_SMALLINT | | |
| SQL_TIME | | |
| SQL_TIMESTAMP | | |
| SQL_TINYINT | | |
| SQL_TSI_DAY | | |
| SQL_TSI_FRAC_SECOND | | |
| SQL_TSI_HOUR | | |
| SQL_TSI_MICROSECOND | | |
| SQL_TSI_MINUTE | | |
| SQL_TSI_MONTH | | |
| SQL_TSI_QUARTER | | |
| SQL_TSI_SECOND | | |
| SQL_TSI_WEEK | | |
| SQL_TSI_YEAR | | |
| SQL_VARBINARY | | |
| SQL_VARCHAR | | |
| SQRT | Reserved | Reserved |
| START | | Reserved |
| STATE | | |
| STATEMENT | | |
| STATIC | | Reserved |
| STDDEV_POP | Reserved | Reserved |
| STDDEV_SAMP | Reserved | Reserved |
| STORAGE | | |
| STREAM | Reserved | |
| STRING_AGG | | |
| STRUCTURE | | |
| STYLE | | |
| SUBCLASS_ORIGIN | | |
| SUBMULTISET | | Reserved |
| SUBSET | | Reserved |
| SUBSTITUTE | | |
| SUBSTRING | Reserved | Reserved |
| SUBSTRING_REGEX | | Reserved |
| SUCCEEDS | | Reserved |
| SUM | Reserved | Reserved |
| SUNDAY | Reserved | |
| SYMMETRIC | Reserved | Reserved |
| SYSTEM | | Reserved |
| SYSTEM_TIME | Reserved | Reserved |
| SYSTEM_USER | Reserved | Reserved |
| TABLE | Reserved | Reserved |
| TABLESAMPLE | Reserved | Reserved |
| TABLE_NAME | | |
| TEMPORARY | | |
| THEN | Reserved | Reserved |
| THURSDAY | Reserved | |
| TIES | | |
| TIME | Reserved | Reserved |
| TIMESTAMP | Reserved | Reserved |
| TIMESTAMPADD | | |
| TIMESTAMPDIFF | | |
| TIMESTAMP_DIFF | | |
| TIMESTAMP_TRUNC | | |
| TIMEZONE_HOUR | | Reserved |
| TIMEZONE_MINUTE | | Reserved |
| TIME_DIFF | | |
| TIME_TRUNC | | |
| TINYINT | | |
| TO | Reserved | Reserved |
| TOP_LEVEL_COUNT | | |
| TRAILING | Reserved | Reserved |
| TRANSACTION | | |
| TRANSACTIONS_ACTIVE | | |
| TRANSACTIONS_COMMITTED | | |
| TRANSACTIONS_ROLLED_BACK | | |
| TRANSFORM | | |
| TRANSFORMS | | |
| TRANSLATE | | Reserved |
| TRANSLATE_REGEX | | Reserved |
| TRANSLATION | | Reserved |
| TREAT | | Reserved |
| TRIGGER | | Reserved |
| TRIGGER_CATALOG | | |
| TRIGGER_NAME | | |
| TRIGGER_SCHEMA | | |
| TRIM | | Reserved |
| TRIM_ARRAY | | Reserved |
| TRUE | Reserved | Reserved |
| TRUNCATE | Reserved | Reserved |
| TRY_CAST | | |
| TUESDAY | Reserved | |
| TUMBLE | | |
| TYPE | | |
| UESCAPE | Reserved | Reserved |
| UNBOUNDED | | |
| UNCOMMITTED | | |
| UNCONDITIONAL | | |
| UNDER | | |
| UNION | Reserved | Reserved |
| UNIQUE | | Reserved |
| UNKNOWN | Reserved | Reserved |
| UNNAMED | | |
| UNNEST | | Reserved |
| UNPIVOT | | |
| UP | | |
| UPDATE | Reserved | Reserved |
| UPPER | Reserved | Reserved |
| UPSERT | Reserved | |
| USAGE | | |
| USER | Reserved | Reserved |
| USER_DEFINED_TYPE_CATALOG | | |
| USER_DEFINED_TYPE_CODE | | |
| USER_DEFINED_TYPE_NAME | | |
| USER_DEFINED_TYPE_SCHEMA | | |
| USING | Reserved | Reserved |
| UTF16 | | |
| UTF32 | | |
| UTF8 | | |
| UUID | Reserved | |
| VALUE | Reserved | Reserved |
| VALUES | Reserved | Reserved |
| VALUE_OF | | Reserved |
| VARBINARY | | Reserved |
| VARCHAR | | Reserved |
| VARIANT | Reserved | |
| VARYING | | Reserved |
| VAR_POP | Reserved | Reserved |
| VAR_SAMP | Reserved | Reserved |
| VERSION | | |
| VERSIONING | | Reserved |
| VIEW | | |
| WAIT | | |
| WEDNESDAY | Reserved | |
| WEEK | | |
| WEEKS | | |
| WHEN | Reserved | Reserved |
| WHENEVER | | Reserved |
| WHERE | Reserved | Reserved |
| WIDTH_BUCKET | | |
| WINDOW | Reserved | Reserved |
| WITH | Reserved | Reserved |
| WITHIN | Reserved | Reserved |
| WITHOUT | | Reserved |
| WORK | | Reserved |
| WRAPPER | | |
| WRITE | | Reserved |
| XML | | Reserved |
| XMLAGG | | Reserved |
| XMLATTRIBUTES | | Reserved |
| XMLBINARY | | Reserved |
| XMLCAST | | Reserved |
| XMLCOMMENT | | Reserved |
| XMLCONCAT | | Reserved |
| XMLDOCUMENT | | Reserved |
| XMLELEMENT | | Reserved |
| XMLEXISTS | | Reserved |
| XMLFOREST | | Reserved |
| XMLITERATE | | Reserved |
| XMLNAMESPACES | | Reserved |
| XMLPARSE | | Reserved |
| XMLPI | | Reserved |
| XMLQUERY | | Reserved |
| XMLSERIALIZE | | Reserved |
| XMLTABLE | | Reserved |
| XMLTEXT | | Reserved |
| XMLVALIDATE | | Reserved |
| YEAR | Reserved | Reserved |
| YEARS | | |
| ZONE | | |