| --- |
| 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 | | | |