| // 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. |
| = Keywords |
| |
| 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. |
| |
| [source, 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.1.0. |
| |
| [cols="1,1,1", options="header"] |
| |=== |
| |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 | | |
| |=== |
