Ключевые слова SQL
В таблице перечислены все токены, которые являются ключевыми словами в стандарте SQL и в QHB. Исходную информацию можно найти в разделе Лексическая-структура (для исторического сравнения включены только две последние версии стандарта SQL и SQL-92. Различия между этими и другими промежуточными стандартными версиями невелики).
SQL различает зарезервированные и незарезервированные ключевые слова. Согласно стандарту, зарезервированные ключевые слова являются полноценными ключевыми словами; они никогда не допускаются в качестве идентификаторов. Незарезервированные ключевые слова имеют особое значение только в определенных контекстах и могут использоваться в качестве идентификаторов в других контекстах. Большинство незарезервированных ключевых слов на самом деле являются именами встроенных таблиц и функций, определенных SQL. Концепция незарезервированных ключевых слов, существует только для того, чтобы объявить, что в некоторых контекстах слову сопоставляется какое-то предопределенное значение.
В парсере QHB существует несколько различных классов токенов, начиная от
тех, которые никогда не могут использоваться в качестве идентификатора,
до тех, которые не имеют никакого специального статуса в
анализаторе по сравнению с обычным идентификатором. (Последнее обычно
имеет место для функций, определенных SQL.) Даже зарезервированные
ключевые слова не могут
использоваться в качестве меток столбцов (например, SELECT 55 AS CHECK
,
даже если CHECK является зарезервированным ключевым словом).
В таблице в столбце для QHB как «non-reserved» определяются те ключевые слова, которые явно известны синтаксическому анализатору, но допускаются как имена столбцов или таблиц. Некоторые ключевые слова, которые в противном случае являются незарезервированными, не могут использоваться в качестве имен функций или типов данных и помечаются соответствующим образом. (Большинство этих слов представляют собой встроенные функции или типы данных со специальным синтаксисом. Функция или тип все еще доступны, но уже не могут быть переопределены пользователем.) Пометкой «reserved» обозначаются те токены, которые не допускаются в качестве имен столбцов или таблиц. Некоторые зарезервированные ключевые слова допустимы в качестве имен для функций или типов данных; это также показано в таблице. Если не отмечено, зарезервированное ключевое слово допускается только в качестве имени метки столбца «AS».
Как правило, если вы получаете ложные ошибки синтаксического анализатора для команд, которые содержат любое из перечисленных ключевых слов в качестве идентификатора, вы должны попытаться заключить в кавычки идентификатор, чтобы увидеть, исчезнет ли проблема.
Перед изучением таблицы важно понять, что тот факт, что ключевое слово не зарезервировано в QHB, не означает, что функция, связанная со словом, не реализована. И наоборот, наличие ключевого слова не указывает на наличие функции.
Таблица Ключевые слова SQL
Ключевое слово | QHB/PostreSQL | SQL: 2016 | SQL: 2011 | SQL-92 |
---|---|---|---|---|
A | non-reserved | non-reserved | ||
ABORT | non-reserved | |||
ABS | reserved | reserved | ||
ABSENT | non-reserved | non-reserved | ||
ABSOLUTE | non-reserved | non-reserved | non-reserved | reserved |
ACCESS | non-reserved | |||
ACCORDING | non-reserved | non-reserved | ||
ACOS | reserved | |||
ACTION | non-reserved | non-reserved | non-reserved | reserved |
ADA | non-reserved | non-reserved | non-reserved | |
ADD | non-reserved | non-reserved | non-reserved | reserved |
ADMIN | non-reserved | non-reserved | non-reserved | |
AFTER | non-reserved | non-reserved | non-reserved | |
AGGREGATE | non-reserved | |||
ALL | reserved | reserved | reserved | reserved |
ALLOCATE | reserved | reserved | reserved | |
ALSO | non-reserved | |||
ALTER | non-reserved | reserved | reserved | reserved |
ALWAYS | non-reserved | non-reserved | non-reserved | |
ANALYSE | reserved | |||
ANALYZE | reserved | |||
AND | reserved | reserved | reserved | reserved |
ANY | reserved | reserved | reserved | reserved |
APPEND_ONLY | reserved (может быть функцией или типом) | non-reserved | non-reserved | non-reserved |
ARE | reserved | reserved | reserved | |
ARRAY | reserved | reserved | reserved | |
ARRAY_AGG | reserved | reserved | ||
ARRAY_MAX_CARDINALITY | reserved | reserved | ||
AS | reserved | reserved | reserved | reserved |
ASC | reserved | non-reserved | non-reserved | reserved |
ASENSITIVE | reserved | reserved | ||
ASIN | reserved | |||
ASSERTION | non-reserved | non-reserved | non-reserved | reserved |
ASSIGNMENT | non-reserved | non-reserved | non-reserved | |
ASYMMETRIC | reserved | reserved | reserved | |
AT | non-reserved | reserved | reserved | reserved |
ATAN | reserved | |||
ATOMIC | reserved | reserved | ||
ATTACH | non-reserved | |||
ATTRIBUTE | non-reserved | non-reserved | non-reserved | |
ATTRIBUTES | non-reserved | non-reserved | ||
AUTHORIZATION | reserved (может быть функцией или типом) | reserved | reserved | reserved |
AVG | reserved | reserved | reserved | |
BACKWARD | non-reserved | |||
BASE64 | non-reserved | non-reserved | ||
BEFORE | non-reserved | non-reserved | non-reserved | |
BEGIN | non-reserved | reserved | reserved | reserved |
BEGIN_FRAME | reserved | reserved | ||
BEGIN_PARTITION | reserved | reserved | ||
BERNOULLI | non-reserved | non-reserved | ||
BETWEEN | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
BIGINT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
BINARY | reserved (может быть функцией или типом) | reserved | reserved | |
BIT | non-reserved (не может быть функцией или типом) | reserved | ||
BIT_LENGTH | reserved | |||
BLOB | reserved | reserved | ||
BLOCKED | non-reserved | non-reserved | ||
BOM | non-reserved | non-reserved | ||
BOOLEAN | non-reserved (не может быть функцией или типом) | reserved | reserved | |
BOTH | reserved | reserved | reserved | reserved |
BREADTH | non-reserved | non-reserved | ||
BY | non-reserved | reserved | reserved | reserved |
C | non-reserved | non-reserved | non-reserved | |
CACHE | non-reserved | |||
CALL | non-reserved | reserved | reserved | |
CALLED | non-reserved | reserved | reserved | |
CARDINALITY | reserved | reserved | ||
CASCADE | non-reserved | non-reserved | non-reserved | reserved |
CASCADED | non-reserved | reserved | reserved | reserved |
CASE | reserved | reserved | reserved | reserved |
CAST | reserved | reserved | reserved | reserved |
CATALOG | non-reserved | non-reserved | non-reserved | reserved |
CATALOG_NAME | non-reserved | non-reserved | non-reserved | |
CEIL | reserved | reserved | ||
CEILING | reserved | reserved | ||
CHAIN | non-reserved | non-reserved | non-reserved | |
CHAINING | non-reserved | |||
CHAR | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
CHARACTER | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
CHARACTERISTICS | non-reserved | non-reserved | non-reserved | |
CHARACTERS | non-reserved | non-reserved | ||
CHARACTER_LENGTH | reserved | reserved | reserved | |
CHARACTER_SET_CATALOG | non-reserved | non-reserved | non-reserved | |
CHARACTER_SET_NAME | non-reserved | non-reserved | non-reserved | |
CHARACTER_SET_SCHEMA | non-reserved | non-reserved | non-reserved | |
CHAR_LENGTH | reserved | reserved | reserved | |
CHECK | reserved | reserved | reserved | reserved |
CHECKPOINT | non-reserved | |||
CLASS | non-reserved | |||
CLASSIFIER | reserved | |||
CLASS_ORIGIN | non-reserved | non-reserved | non-reserved | |
CLOB | reserved | reserved | ||
CLOSE | non-reserved | reserved | reserved | reserved |
CLUSTER | non-reserved | |||
COALESCE | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
COBOL | non-reserved | non-reserved | non-reserved | |
COLLATE | reserved | reserved | reserved | reserved |
COLLATION | reserved (может быть функцией или типом) | non-reserved | non-reserved | reserved |
COLLATION_CATALOG | non-reserved | non-reserved | non-reserved | |
COLLATION_NAME | non-reserved | non-reserved | non-reserved | |
COLLATION_SCHEMA | non-reserved | non-reserved | non-reserved | |
COLLECT | reserved | reserved | ||
COLUMN | reserved | reserved | reserved | reserved |
COLUMNS | non-reserved | non-reserved | non-reserved | |
COLUMN_NAME | non-reserved | non-reserved | non-reserved | |
COMMAND_FUNCTION | non-reserved | non-reserved | non-reserved | |
COMMAND_FUNCTION_CODE | non-reserved | non-reserved | ||
COMMENT | non-reserved | |||
COMMENTS | non-reserved | |||
COMMIT | non-reserved | reserved | reserved | reserved |
COMMITTED | non-reserved | non-reserved | non-reserved | non-reserved |
CONCURRENTLY | reserved (может быть функцией или типом) | |||
CONDITION | reserved | reserved | ||
CONDITIONAL | non-reserved | |||
CONDITION_NUMBER | non-reserved | non-reserved | non-reserved | |
CONFIGURATION | non-reserved | |||
CONFLICT | non-reserved | |||
CONNECT | reserved | reserved | reserved | |
CONNECTION | non-reserved | non-reserved | non-reserved | reserved |
CONNECTION_NAME | non-reserved | non-reserved | non-reserved | |
CONSTRAINT | reserved | reserved | reserved | reserved |
CONSTRAINTS | non-reserved | non-reserved | non-reserved | reserved |
CONSTRAINT_CATALOG | non-reserved | non-reserved | non-reserved | |
CONSTRAINT_NAME | non-reserved | non-reserved | non-reserved | |
CONSTRAINT_SCHEMA | non-reserved | non-reserved | non-reserved | |
CONSTRUCTOR | non-reserved | non-reserved | ||
CONTAINS | reserved | reserved | ||
CONTENT | non-reserved | non-reserved | non-reserved | |
CONTINUE | non-reserved | non-reserved | non-reserved | reserved |
CONTROL | non-reserved | non-reserved | ||
CONVERSION | non-reserved | |||
CONVERT | reserved | reserved | reserved | |
COPY | non-reserved | reserved | ||
CORR | reserved | reserved | ||
CORRESPONDING | reserved | reserved | reserved | |
COS | reserved | |||
COSH | reserved | |||
COST | non-reserved | |||
COUNT | reserved | reserved | reserved | |
COVAR_POP | reserved | reserved | ||
COVAR_SAMP | reserved | reserved | ||
CREATE | reserved | reserved | reserved | reserved |
CROSS | reserved (может быть функцией или типом) | reserved | reserved | reserved |
CSV | non-reserved | |||
CUBE | non-reserved | reserved | reserved | |
CUME_DIST | reserved | reserved | ||
CURRENT | non-reserved | reserved | reserved | reserved |
CURRENT_CATALOG | reserved | reserved | reserved | |
CURRENT_DATE | reserved | reserved | reserved | reserved |
CURRENT_DEFAULT_TRANSFORM_GROUP | reserved | reserved | ||
CURRENT_PATH | reserved | reserved | ||
CURRENT_ROLE | reserved | reserved | reserved | |
CURRENT_ROW | reserved | reserved | ||
CURRENT_SCHEMA | reserved (может быть функцией или типом) | reserved | reserved | |
CURRENT_TIME | reserved | reserved | reserved | reserved |
CURRENT_TIMESTAMP | reserved | reserved | reserved | reserved |
CURRENT_TRANSFORM_GROUP_FOR_TYPE | reserved | reserved | ||
CURRENT_USER | reserved | reserved | reserved | reserved |
CURSOR | non-reserved | reserved | reserved | reserved |
CURSOR_NAME | non-reserved | non-reserved | non-reserved | |
CYCLE | non-reserved | reserved | reserved | |
DATA | non-reserved | non-reserved | non-reserved | non-reserved |
DATABASE | non-reserved | |||
DATALINK | reserved | reserved | ||
DATE | reserved | reserved | reserved | |
DATETIME_INTERVAL_CODE | non-reserved | non-reserved | non-reserved | |
DATETIME_INTERVAL_PRECISION | non-reserved | non-reserved | non-reserved | |
DAY | non-reserved | reserved | reserved | reserved |
DB | non-reserved | non-reserved | ||
DEALLOCATE | non-reserved | reserved | reserved | reserved |
DEC | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
DECFLOAT | reserved | |||
DECIMAL | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
DECLARE | non-reserved | reserved | reserved | reserved |
DEFAULT | reserved | reserved | reserved | reserved |
DEFAULTS | non-reserved | non-reserved | non-reserved | |
DEFERRABLE | reserved | non-reserved | non-reserved | reserved |
DEFERRED | non-reserved | non-reserved | non-reserved | reserved |
DEFINE | reserved | |||
DEFINED | non-reserved | non-reserved | ||
DEFINER | non-reserved | non-reserved | non-reserved | |
DEGREE | non-reserved | non-reserved | ||
DELETE | non-reserved | reserved | reserved | reserved |
DELIMITER | non-reserved | |||
DELIMITERS | non-reserved | |||
DENSE_RANK | reserved | reserved | ||
DEPENDS | non-reserved | |||
DEPTH | non-reserved | non-reserved | ||
DEREF | reserved | reserved | ||
DERIVED | non-reserved | non-reserved | ||
DESC | reserved | non-reserved | non-reserved | reserved |
DESCRIBE | reserved | reserved | reserved | |
DESCRIPTOR | non-reserved | non-reserved | reserved | |
DETACH | non-reserved | |||
DETERMINISTIC | reserved | reserved | ||
DIAGNOSTICS | non-reserved | non-reserved | reserved | |
DICTIONARY | non-reserved | |||
DISABLE | non-reserved | |||
DISCARD | non-reserved | |||
DISCONNECT | reserved | reserved | reserved | |
DISPATCH | non-reserved | non-reserved | ||
DISTINCT | reserved | reserved | reserved | reserved |
DLNEWCOPY | reserved | reserved | ||
DLPREVIOUSCOPY | reserved | reserved | ||
DLURLCOMPLETE | reserved | reserved | ||
DLURLCOMPLETEONLY | reserved | reserved | ||
DLURLCOMPLETEWRITE | reserved | reserved | ||
DLURLPATH | reserved | reserved | ||
DLURLPATHONLY | reserved | reserved | ||
DLURLPATHWRITE | reserved | reserved | ||
DLURLSCHEME | reserved | reserved | ||
DLURLSERVER | reserved | reserved | ||
DLVALUE | reserved | reserved | ||
DO | reserved | |||
DOCUMENT | non-reserved | non-reserved | non-reserved | |
DOMAIN | non-reserved | non-reserved | non-reserved | reserved |
DOUBLE | non-reserved | reserved | reserved | reserved |
DROP | non-reserved | reserved | reserved | reserved |
DYNAMIC | reserved | reserved | ||
DYNAMIC_FUNCTION | non-reserved | non-reserved | non-reserved | |
DYNAMIC_FUNCTION_CODE | non-reserved | non-reserved | ||
EACH | non-reserved | reserved | reserved | |
ELEMENT | reserved | reserved | ||
ELSE | reserved | reserved | reserved | reserved |
EMPTY | reserved | non-reserved | ||
ENABLE | non-reserved | |||
ENCODING | non-reserved | non-reserved | non-reserved | |
ENCRYPTED | non-reserved | |||
END | reserved | reserved | reserved | reserved |
END-EXEC | reserved | reserved | reserved | |
END_FRAME | reserved | reserved | ||
END_PARTITION | reserved | reserved | ||
ENFORCED | non-reserved | non-reserved | ||
ENUM | non-reserved | |||
EQUALS | reserved | reserved | ||
ERROR | non-reserved | |||
ESCAPE | non-reserved | reserved | reserved | reserved |
EVENT | non-reserved | |||
EVERY | reserved | reserved | ||
EXCEPT | reserved | reserved | reserved | reserved |
EXCEPTION | reserved | |||
EXCLUDE | non-reserved | non-reserved | non-reserved | |
EXCLUDING | non-reserved | non-reserved | non-reserved | |
EXCLUSIVE | non-reserved | |||
EXEC | reserved | reserved | reserved | |
EXECUTE | non-reserved | reserved | reserved | reserved |
EXISTS | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
EXP | reserved | reserved | ||
EXPLAIN | non-reserved | |||
EXPRESSION | non-reserved | non-reserved | ||
EXTENSION | non-reserved | |||
EXTERNAL | non-reserved | reserved | reserved | reserved |
EXTRACT | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
FALSE | reserved | reserved | reserved | reserved |
FAMILY | non-reserved | |||
FETCH | reserved | reserved | reserved | reserved |
FILE | non-reserved | non-reserved | ||
FILTER | non-reserved | reserved | reserved | |
FINAL | non-reserved | non-reserved | ||
FINISH | non-reserved | |||
FIRST | non-reserved | non-reserved | non-reserved | reserved |
FIRST_VALUE | reserved | reserved | ||
FLAG | non-reserved | non-reserved | ||
FLOAT | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
FLOOR | reserved | reserved | ||
FOLLOWING | non-reserved | non-reserved | non-reserved | |
FOR | reserved | reserved | reserved | reserved |
FORCE | non-reserved | |||
FOREIGN | reserved | reserved | reserved | reserved |
FORMAT | non-reserved | |||
FORTRAN | non-reserved | non-reserved | non-reserved | |
FORWARD | non-reserved | |||
FOUND | non-reserved | non-reserved | reserved | |
FRAME_ROW | reserved | reserved | ||
FREE | reserved | reserved | ||
FREEZE | reserved (может быть функцией или типом) | |||
FROM | reserved | reserved | reserved | reserved |
FS | non-reserved | non-reserved | ||
FULFILL | non-reserved | |||
FULL | reserved (может быть функцией или типом) | reserved | reserved | reserved |
FUNCTION | non-reserved | reserved | reserved | |
FUNCTIONS | non-reserved | |||
FUSION | reserved | reserved | ||
G | non-reserved | non-reserved | ||
GENERAL | non-reserved | non-reserved | ||
GENERATED | non-reserved | non-reserved | non-reserved | |
GET | reserved | reserved | reserved | |
GLOBAL | non-reserved | reserved | reserved | reserved |
GO | non-reserved | non-reserved | reserved | |
GOTO | non-reserved | non-reserved | reserved | |
GRANT | reserved | reserved | reserved | reserved |
GRANTED | non-reserved | non-reserved | non-reserved | |
GREATEST | non-reserved (не может быть функцией или типом) | |||
GROUP | reserved | reserved | reserved | reserved |
GROUPING | non-reserved (не может быть функцией или типом) | reserved | reserved | |
GROUPS | non-reserved | reserved | reserved | |
HANDLER | non-reserved | |||
HAVING | reserved | reserved | reserved | reserved |
HEADER | non-reserved | |||
HEX | non-reserved | non-reserved | ||
HIERARCHY | non-reserved | non-reserved | ||
HOLD | non-reserved | reserved | reserved | |
HOUR | non-reserved | reserved | reserved | reserved |
ID | non-reserved | non-reserved | ||
IDENTITY | non-reserved | reserved | reserved | reserved |
IF | non-reserved | |||
IGNORE | non-reserved | non-reserved | ||
ILIKE | reserved (может быть функцией или типом) | |||
IMMEDIATE | non-reserved | non-reserved | non-reserved | reserved |
IMMEDIATELY | non-reserved | non-reserved | ||
IMMUTABLE | non-reserved | |||
IMPLEMENTATION | non-reserved | non-reserved | ||
IMPLICIT | non-reserved | |||
IMPORT | non-reserved | reserved | reserved | |
IN | reserved | reserved | reserved | reserved |
INCLUDE | non-reserved | |||
INCLUDING | non-reserved | non-reserved | non-reserved | |
INCREMENT | non-reserved | non-reserved | non-reserved | |
INDENT | non-reserved | non-reserved | ||
INDEX | non-reserved | |||
INDEXES | non-reserved | |||
INDICATOR | reserved | reserved | reserved | |
INHERIT | non-reserved | |||
INHERITS | non-reserved | |||
INITIAL | reserved | |||
INITIALLY | reserved | non-reserved | non-reserved | reserved |
INLINE | non-reserved | |||
INNER | reserved (может быть функцией или типом) | reserved | reserved | reserved |
INOUT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
INPUT | non-reserved | non-reserved | non-reserved | reserved |
INSENSITIVE | non-reserved | reserved | reserved | reserved |
INSERT | non-reserved | reserved | reserved | reserved |
INSTANCE | non-reserved | non-reserved | ||
INSTANTIABLE | non-reserved | non-reserved | ||
INSTEAD | non-reserved | non-reserved | non-reserved | |
INT | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
INTEGER | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
INTEGRITY | non-reserved | non-reserved | ||
INTERSECT | reserved | reserved | reserved | reserved |
INTERSECTION | reserved | reserved | ||
INTERVAL | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
INTO | reserved | reserved | reserved | reserved |
INVOKER | non-reserved | non-reserved | non-reserved | |
IS | reserved (может быть функцией или типом) | reserved | reserved | reserved |
ISNULL | reserved (может быть функцией или типом) | |||
ISOLATION | non-reserved | non-reserved | non-reserved | reserved |
JOIN | reserved (может быть функцией или типом) | reserved | reserved | reserved |
JSON | non-reserved | |||
JSON_ARRAY | reserved | |||
JSON_ARRAYAGG | reserved | |||
JSON_EXISTS | reserved | |||
JSON_OBJECT | reserved | |||
JSON_OBJECTAGG | reserved | |||
JSON_QUERY | reserved | |||
JSON_TABLE | reserved | |||
JSON_TABLE_PRIMITIVE | reserved | |||
JSON_VALUE | reserved | |||
K | non-reserved | non-reserved | ||
KEEP | non-reserved | |||
KEY | non-reserved | non-reserved | non-reserved | reserved |
KEYS | non-reserved | |||
KEY_MEMBER | non-reserved | non-reserved | ||
KEY_TYPE | non-reserved | non-reserved | ||
LABEL | non-reserved | |||
LAG | reserved | reserved | ||
LANGUAGE | non-reserved | reserved | reserved | reserved |
LARGE | non-reserved | reserved | reserved | |
LAST | non-reserved | non-reserved | non-reserved | reserved |
LAST_VALUE | reserved | reserved | ||
LATERAL | reserved | reserved | reserved | |
LEAD | reserved | reserved | ||
LEADING | reserved | reserved | reserved | reserved |
LEAKPROOF | non-reserved | |||
LEAST | non-reserved (не может быть функцией или типом) | |||
LEFT | reserved (может быть функцией или типом) | reserved | reserved | reserved |
LENGTH | non-reserved | non-reserved | non-reserved | |
LEVEL | non-reserved | non-reserved | non-reserved | reserved |
LIBRARY | non-reserved | non-reserved | ||
LIKE | reserved (может быть функцией или типом) | reserved | reserved | reserved |
LIKE_REGEX | reserved | reserved | ||
LIMIT | reserved | non-reserved | non-reserved | |
LINK | non-reserved | non-reserved | ||
LISTAGG | reserved | |||
LISTEN | non-reserved | |||
LN | reserved | reserved | ||
LOAD | non-reserved | |||
LOCAL | non-reserved | reserved | reserved | reserved |
LOCALTIME | reserved | reserved | reserved | |
LOCALTIMESTAMP | reserved | reserved | reserved | |
LOCATION | non-reserved | non-reserved | non-reserved | |
LOCATOR | non-reserved | non-reserved | ||
LOCK | non-reserved | |||
LOCKED | non-reserved | |||
LOG | reserved | |||
LOG10 | reserved | |||
LOGGED | non-reserved | |||
LOWER | reserved | reserved | reserved | |
M | non-reserved | non-reserved | ||
MAP | non-reserved | non-reserved | ||
MAPPING | non-reserved | non-reserved | non-reserved | |
MATCH | non-reserved | reserved | reserved | reserved |
MATCHED | non-reserved | non-reserved | ||
MATCHES | reserved | |||
MATCH_NUMBER | reserved | |||
MATCH_RECOGNIZE | reserved | |||
MATERIALIZED | non-reserved | |||
MAX | reserved | reserved | reserved | |
MAXVALUE | non-reserved | non-reserved | non-reserved | |
MEASURES | reserved | |||
MEMBER | reserved | reserved | ||
MERGE | reserved | reserved | ||
MESSAGE_LENGTH | non-reserved | non-reserved | non-reserved | |
MESSAGE_OCTET_LENGTH | non-reserved | non-reserved | non-reserved | |
MESSAGE_TEXT | non-reserved | non-reserved | non-reserved | |
METHOD | non-reserved | reserved | reserved | |
MIN | reserved | reserved | reserved | |
MINUTE | non-reserved | reserved | reserved | reserved |
MINVALUE | non-reserved | non-reserved | non-reserved | |
MOD | reserved | reserved | ||
MODE | non-reserved | |||
MODIFIES | reserved | reserved | ||
MODULE | reserved | reserved | reserved | |
MONTH | non-reserved | reserved | reserved | reserved |
MORE | non-reserved | non-reserved | non-reserved | |
MOVE | non-reserved | |||
MULTISET | reserved | reserved | ||
MUMPS | non-reserved | non-reserved | non-reserved | |
NAME | non-reserved | non-reserved | non-reserved | non-reserved |
NAMES | non-reserved | non-reserved | non-reserved | reserved |
NAMESPACE | non-reserved | non-reserved | ||
NATIONAL | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
NATURAL | reserved (может быть функцией или типом) | reserved | reserved | reserved |
NCHAR | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
NCLOB | reserved | reserved | ||
NESTED | non-reserved | |||
NESTING | non-reserved | non-reserved | ||
NEW | non-reserved | reserved | reserved | |
NEXT | non-reserved | non-reserved | non-reserved | reserved |
NFC | non-reserved | non-reserved | ||
NFD | non-reserved | non-reserved | ||
NFKC | non-reserved | non-reserved | ||
NFKD | non-reserved | non-reserved | ||
NIL | non-reserved | non-reserved | ||
NO | non-reserved | reserved | reserved | reserved |
NONE | non-reserved (не может быть функцией или типом) | reserved | reserved | |
NORMALIZE | reserved | reserved | ||
NORMALIZED | non-reserved | non-reserved | ||
NOT | reserved | reserved | reserved | reserved |
NOTHING | non-reserved | |||
NOTIFY | non-reserved | |||
NOTNULL | reserved (может быть функцией или типом) | |||
NOWAIT | non-reserved | |||
NTH_VALUE | reserved | reserved | ||
NTILE | reserved | reserved | ||
NULL | reserved | reserved | reserved | reserved |
NULLABLE | non-reserved | non-reserved | non-reserved | |
NULLIF | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
NULLS | non-reserved | non-reserved | non-reserved | |
NUMBER | non-reserved | non-reserved | non-reserved | |
NUMERIC | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
OBJECT | non-reserved | non-reserved | non-reserved | |
OCCURRENCES_REGEX | reserved | reserved | ||
OCTETS | non-reserved | non-reserved | ||
OCTET_LENGTH | reserved | reserved | reserved | |
OF | non-reserved | reserved | reserved | reserved |
OFF | non-reserved | non-reserved | non-reserved | |
OFFSET | reserved | reserved | reserved | |
OIDS | non-reserved | |||
OLD | non-reserved | reserved | reserved | |
OMIT | reserved | |||
ON | reserved | reserved | reserved | reserved |
ONE | reserved | |||
ONLY | reserved | reserved | reserved | reserved |
OPEN | reserved | reserved | reserved | |
OPERATOR | non-reserved | |||
OPTION | non-reserved | non-reserved | non-reserved | reserved |
OPTIONS | non-reserved | non-reserved | non-reserved | |
OR | reserved | reserved | reserved | reserved |
ORDER | reserved | reserved | reserved | reserved |
ORDERING | non-reserved | non-reserved | ||
ORDINALITY | non-reserved | non-reserved | non-reserved | |
OTHERS | non-reserved | non-reserved | non-reserved | |
OUT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
OUTER | reserved (может быть функцией или типом) | reserved | reserved | reserved |
OUTPUT | non-reserved | non-reserved | reserved | |
OVER | non-reserved | reserved | reserved | |
OVERFLOW | non-reserved | |||
OVERLAPS | reserved (может быть функцией или типом) | reserved | reserved | reserved |
OVERLAY | non-reserved (не может быть функцией или типом) | reserved | reserved | |
OVERRIDING | non-reserved | non-reserved | non-reserved | |
OWNED | non-reserved | |||
OWNER | non-reserved | |||
P | non-reserved | non-reserved | ||
PAD | non-reserved | non-reserved | reserved | |
PARALLEL | non-reserved | |||
PARAMETER | reserved | reserved | ||
PARAMETER_MODE | non-reserved | non-reserved | ||
PARAMETER_NAME | non-reserved | non-reserved | ||
PARAMETER_ORDINAL_POSITION | non-reserved | non-reserved | ||
PARAMETER_SPECIFIC_CATALOG | non-reserved | non-reserved | ||
PARAMETER_SPECIFIC_NAME | non-reserved | non-reserved | ||
PARAMETER_SPECIFIC_SCHEMA | non-reserved | non-reserved | ||
PARSER | non-reserved | |||
PARTIAL | non-reserved | non-reserved | non-reserved | reserved |
PARTITION | non-reserved | reserved | reserved | |
PASCAL | non-reserved | non-reserved | non-reserved | |
PASS | non-reserved | |||
PASSING | non-reserved | non-reserved | non-reserved | |
PASSTHROUGH | non-reserved | non-reserved | ||
PASSWORD | non-reserved | |||
PAST | non-reserved | |||
PATH | non-reserved | non-reserved | ||
PATTERN | reserved | |||
PER | reserved | |||
PERCENT | reserved | reserved | ||
PERCENTILE_CONT | reserved | reserved | ||
PERCENTILE_DISC | reserved | reserved | ||
PERCENT_RANK | reserved | reserved | ||
PERIOD | reserved | reserved | ||
PERMISSION | non-reserved | non-reserved | ||
PERMUTE | reserved | |||
PLACING | reserved | non-reserved | non-reserved | |
PLAN | non-reserved | |||
PLANS | non-reserved | |||
PLI | non-reserved | non-reserved | non-reserved | |
POLICY | non-reserved | |||
PORTION | reserved | reserved | ||
POSITION | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
POSITION_REGEX | reserved | reserved | ||
POWER | reserved | reserved | ||
PRECEDES | reserved | reserved | ||
PRECEDING | non-reserved | non-reserved | non-reserved | |
PRECISION | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
PREPARE | non-reserved | reserved | reserved | reserved |
PREPARED | non-reserved | |||
PRESERVE | non-reserved | non-reserved | non-reserved | reserved |
PRIMARY | reserved | reserved | reserved | reserved |
PRIOR | non-reserved | non-reserved | non-reserved | reserved |
PRIVATE | non-reserved | |||
PRIVILEGES | non-reserved | non-reserved | non-reserved | reserved |
PROCEDURAL | non-reserved | |||
PROCEDURE | non-reserved | reserved | reserved | reserved |
PROCEDURES | non-reserved | |||
PROGRAM | non-reserved | |||
PRUNE | non-reserved | |||
PTF | reserved | |||
PUBLIC | non-reserved | non-reserved | reserved | |
PUBLICATION | non-reserved | |||
QUOTE | non-reserved | |||
QUOTES | non-reserved | |||
RANGE | non-reserved | reserved | reserved | |
RANK | reserved | reserved | ||
READ | non-reserved | non-reserved | non-reserved | reserved |
READS | reserved | reserved | ||
REAL | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
REASSIGN | non-reserved | |||
RECHECK | non-reserved | |||
RECOVERY | non-reserved | non-reserved | ||
RECURSIVE | non-reserved | reserved | reserved | |
REF | non-reserved | reserved | reserved | |
REFERENCES | reserved | reserved | reserved | reserved |
REFERENCING | non-reserved | reserved | reserved | |
REFRESH | non-reserved | |||
REGR_AVGX | reserved | reserved | ||
REGR_AVGY | reserved | reserved | ||
REGR_COUNT | reserved | reserved | ||
REGR_INTERCEPT | reserved | reserved | ||
REGR_R2 | reserved | reserved | ||
REGR_SLOPE | reserved | reserved | ||
REGR_SXX | reserved | reserved | ||
REGR_SXY | reserved | reserved | ||
REGR_SYY | reserved | reserved | ||
REINDEX | non-reserved | |||
RELATIVE | non-reserved | non-reserved | non-reserved | reserved |
RELEASE | non-reserved | reserved | reserved | |
RENAME | non-reserved | |||
REPEATABLE | non-reserved | non-reserved | non-reserved | non-reserved |
REPLACE | non-reserved | |||
REPLICA | non-reserved | |||
REQUIRING | non-reserved | non-reserved | ||
RESET | non-reserved | |||
RESPECT | non-reserved | non-reserved | ||
RESTART | non-reserved | non-reserved | non-reserved | |
RESTORE | non-reserved | non-reserved | ||
RESTRICT | non-reserved | non-reserved | non-reserved | reserved |
RESULT | reserved | reserved | ||
RETURN | reserved | reserved | ||
RETURNED_CARDINALITY | non-reserved | non-reserved | ||
RETURNED_LENGTH | non-reserved | non-reserved | non-reserved | |
RETURNED_OCTET_LENGTH | non-reserved | non-reserved | non-reserved | |
RETURNED_SQLSTATE | non-reserved | non-reserved | non-reserved | |
RETURNING | reserved | non-reserved | non-reserved | |
RETURNS | non-reserved | reserved | reserved | |
REVOKE | non-reserved | reserved | reserved | reserved |
RIGHT | reserved (может быть функцией или типом) | reserved | reserved | reserved |
ROLE | non-reserved | non-reserved | non-reserved | |
ROLLBACK | non-reserved | reserved | reserved | reserved |
ROLLUP | non-reserved | reserved | reserved | |
ROUTINE | non-reserved | non-reserved | non-reserved | |
ROUTINES | non-reserved | |||
ROUTINE_CATALOG | non-reserved | non-reserved | ||
ROUTINE_NAME | non-reserved | non-reserved | ||
ROUTINE_SCHEMA | non-reserved | non-reserved | ||
ROW | non-reserved (не может быть функцией или типом) | reserved | reserved | |
ROWS | non-reserved | reserved | reserved | reserved |
ROW_COUNT | non-reserved | non-reserved | non-reserved | |
ROW_NUMBER | reserved | reserved | ||
RULE | non-reserved | |||
RUNNING | reserved | |||
SAVEPOINT | non-reserved | reserved | reserved | |
SCALAR | non-reserved | |||
SCALE | non-reserved | non-reserved | non-reserved | |
SCHEMA | non-reserved | non-reserved | non-reserved | reserved |
SCHEMAS | non-reserved | |||
SCHEMA_NAME | non-reserved | non-reserved | non-reserved | |
SCOPE | reserved | reserved | ||
SCOPE_CATALOG | non-reserved | non-reserved | ||
SCOPE_NAME | non-reserved | non-reserved | ||
SCOPE_SCHEMA | non-reserved | non-reserved | ||
SCROLL | non-reserved | reserved | reserved | reserved |
SEARCH | non-reserved | reserved | reserved | |
SECOND | non-reserved | reserved | reserved | reserved |
SECTION | non-reserved | non-reserved | reserved | |
SECURITY | non-reserved | non-reserved | non-reserved | |
SEEK | reserved | |||
SELECT | reserved | reserved | reserved | reserved |
SELECTIVE | non-reserved | non-reserved | ||
SELF | non-reserved | non-reserved | ||
SENSITIVE | reserved | reserved | ||
SEQUENCE | non-reserved | non-reserved | non-reserved | |
SEQUENCES | non-reserved | |||
SERIALIZABLE | non-reserved | non-reserved | non-reserved | non-reserved |
SERVER | non-reserved | non-reserved | non-reserved | |
SERVER_NAME | non-reserved | non-reserved | non-reserved | |
SESSION | non-reserved | non-reserved | non-reserved | reserved |
SESSION_USER | reserved | reserved | reserved | reserved |
SET | non-reserved | reserved | reserved | reserved |
SETOF | non-reserved (не может быть функцией или типом) | |||
SETS | non-reserved | non-reserved | non-reserved | |
SHARE | non-reserved | |||
SHOW | non-reserved | reserved | ||
SIMILAR | reserved (может быть функцией или типом) | reserved | reserved | |
SIMPLE | non-reserved | non-reserved | non-reserved | |
SIN | reserved | |||
SINH | reserved | |||
SIZE | non-reserved | non-reserved | reserved | |
SKIP | non-reserved | reserved | ||
SMALLINT | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
SNAPSHOT | non-reserved | |||
SOME | reserved | reserved | reserved | reserved |
SOURCE | non-reserved | non-reserved | ||
SPACE | non-reserved | non-reserved | reserved | |
SPECIFIC | reserved | reserved | ||
SPECIFICTYPE | reserved | reserved | ||
SPECIFIC_NAME | non-reserved | non-reserved | ||
SQL | non-reserved | reserved | reserved | reserved |
SQLCODE | reserved | |||
SQLERROR | reserved | |||
SQLEXCEPTION | reserved | reserved | ||
SQLSTATE | reserved | reserved | reserved | |
SQLWARNING | reserved | reserved | ||
SQRT | reserved | reserved | ||
STABLE | non-reserved | |||
STANDALONE | non-reserved | non-reserved | non-reserved | |
START | non-reserved | reserved | reserved | |
STATE | non-reserved | non-reserved | ||
STATEMENT | non-reserved | non-reserved | non-reserved | |
STATIC | reserved | reserved | ||
STATISTICS | non-reserved | |||
STDDEV_POP | reserved | reserved | ||
STDDEV_SAMP | reserved | reserved | ||
STDIN | non-reserved | |||
STDOUT | non-reserved | |||
STORAGE | non-reserved | |||
STORED | non-reserved | |||
STRICT | non-reserved | |||
STRING | non-reserved | |||
STRIP | non-reserved | non-reserved | non-reserved | |
STRUCTURE | non-reserved | non-reserved | ||
STYLE | non-reserved | non-reserved | ||
SUBCLASS_ORIGIN | non-reserved | non-reserved | non-reserved | |
SUBMULTISET | reserved | reserved | ||
SUBSCRIPTION | non-reserved | |||
SUBSET | reserved | |||
SUBSTRING | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
SUBSTRING_REGEX | reserved | reserved | ||
SUCCEEDS | reserved | reserved | ||
SUM | reserved | reserved | reserved | |
SUPPORT | non-reserved | |||
SYMMETRIC | reserved | reserved | reserved | |
SYSID | non-reserved | |||
SYSTEM | non-reserved | reserved | reserved | |
SYSTEM_TIME | reserved | reserved | ||
SYSTEM_USER | reserved | reserved | reserved | |
T | non-reserved | non-reserved | ||
TABLE | reserved | reserved | reserved | reserved |
TABLES | non-reserved | |||
TABLESAMPLE | reserved (может быть функцией или типом) | reserved | reserved | |
TABLESPACE | non-reserved | |||
TABLE_NAME | non-reserved | non-reserved | non-reserved | |
TAN | reserved | |||
TANH | reserved | |||
TEMP | non-reserved | |||
TEMPLATE | non-reserved | |||
TEMPORARY | non-reserved | non-reserved | non-reserved | reserved |
TEXT | non-reserved | |||
THEN | reserved | reserved | reserved | reserved |
THROUGH | non-reserved | |||
TIES | non-reserved | non-reserved | non-reserved | |
TIME | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
TIMESTAMP | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
TIMEZONE_HOUR | reserved | reserved | reserved | |
TIMEZONE_MINUTE | reserved | reserved | reserved | |
TO | reserved | reserved | reserved | reserved |
TOKEN | non-reserved | non-reserved | ||
TOP_LEVEL_COUNT | non-reserved | non-reserved | ||
TRAILING | reserved | reserved | reserved | reserved |
TRANSACTION | non-reserved | non-reserved | non-reserved | reserved |
TRANSACTIONS_COMMITTED | non-reserved | non-reserved | ||
TRANSACTIONS_ROLLED_BACK | non-reserved | non-reserved | ||
TRANSACTION_ACTIVE | non-reserved | non-reserved | ||
TRANSFORM | non-reserved | non-reserved | non-reserved | |
TRANSFORMS | non-reserved | non-reserved | ||
TRANSLATE | reserved | reserved | reserved | |
TRANSLATE_REGEX | reserved | reserved | ||
TRANSLATION | reserved | reserved | reserved | |
TREAT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
TRIGGER | non-reserved | reserved | reserved | |
TRIGGER_CATALOG | non-reserved | non-reserved | ||
TRIGGER_NAME | non-reserved | non-reserved | ||
TRIGGER_SCHEMA | non-reserved | non-reserved | ||
TRIM | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
TRIM_ARRAY | reserved | reserved | ||
TRUE | reserved | reserved | reserved | reserved |
TRUNCATE | non-reserved | reserved | reserved | |
TRUSTED | non-reserved | |||
TYPE | non-reserved | non-reserved | non-reserved | non-reserved |
TYPES | non-reserved | |||
UESCAPE | reserved | reserved | ||
UNBOUNDED | non-reserved | non-reserved | non-reserved | |
UNCOMMITTED | non-reserved | non-reserved | non-reserved | non-reserved |
UNCONDITIONAL | non-reserved | |||
UNDER | non-reserved | non-reserved | ||
UNENCRYPTED | non-reserved | |||
UNION | reserved | reserved | reserved | reserved |
UNIQUE | reserved | reserved | reserved | reserved |
UNKNOWN | non-reserved | reserved | reserved | reserved |
UNLINK | non-reserved | non-reserved | ||
UNLISTEN | non-reserved | |||
UNLOGGED | non-reserved | |||
UNMATCHED | reserved | |||
UNNAMED | non-reserved | non-reserved | non-reserved | |
UNNEST | reserved | reserved | ||
UNTIL | non-reserved | |||
UNTYPED | non-reserved | non-reserved | ||
UPDATE | non-reserved | reserved | reserved | reserved |
UPPER | reserved | reserved | reserved | |
URI | non-reserved | non-reserved | ||
USAGE | non-reserved | non-reserved | reserved | |
USER | reserved | reserved | reserved | reserved |
USER_DEFINED_TYPE_CATALOG | non-reserved | non-reserved | ||
USER_DEFINED_TYPE_CODE | non-reserved | non-reserved | ||
USER_DEFINED_TYPE_NAME | non-reserved | non-reserved | ||
USER_DEFINED_TYPE_SCHEMA | non-reserved | non-reserved | ||
USING | reserved | reserved | reserved | reserved |
UTF16 | non-reserved | |||
UTF32 | non-reserved | |||
UTF8 | non-reserved | |||
VACUUM | non-reserved | |||
VALID | non-reserved | non-reserved | non-reserved | |
VALIDATE | non-reserved | |||
VALIDATOR | non-reserved | |||
VALUE | non-reserved | reserved | reserved | reserved |
VALUES | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
VALUE_OF | reserved | reserved | ||
VARBINARY | reserved | reserved | ||
VARCHAR | non-reserved (не может быть функцией или типом) | reserved | reserved | reserved |
VARIADIC | reserved | |||
VARYING | non-reserved | reserved | reserved | reserved |
VAR_POP | reserved | reserved | ||
VAR_SAMP | reserved | reserved | ||
VERBOSE | reserved (может быть функцией или типом) | |||
VERSION | non-reserved | non-reserved | non-reserved | |
VERSIONING | reserved | reserved | ||
VIEW | non-reserved | non-reserved | non-reserved | reserved |
VIEWS | non-reserved | |||
VOLATILE | non-reserved | |||
WHEN | reserved | reserved | reserved | reserved |
WHENEVER | reserved | reserved | reserved | |
WHERE | reserved | reserved | reserved | reserved |
WHITESPACE | non-reserved | non-reserved | non-reserved | |
WIDTH_BUCKET | reserved | reserved | ||
WINDOW | reserved | reserved | reserved | |
WITH | reserved | reserved | reserved | reserved |
WITHIN | non-reserved | reserved | reserved | |
WITHOUT | non-reserved | reserved | reserved | |
WORK | non-reserved | non-reserved | non-reserved | reserved |
WRAPPER | non-reserved | non-reserved | non-reserved | |
WRITE | non-reserved | non-reserved | non-reserved | reserved |
XML | non-reserved | reserved | reserved | |
XMLAGG | reserved | reserved | ||
XMLATTRIBUTES | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLBINARY | reserved | reserved | ||
XMLCAST | reserved | reserved | ||
XMLCOMMENT | reserved | reserved | ||
XMLCONCAT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLDECLARATION | non-reserved | non-reserved | ||
XMLDOCUMENT | reserved | reserved | ||
XMLELEMENT | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLEXISTS | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLFOREST | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLITERATE | reserved | reserved | ||
XMLNAMESPACES | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLPARSE | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLPI | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLQUERY | reserved | reserved | ||
XMLROOT | non-reserved (не может быть функцией или типом) | |||
XMLSCHEMA | non-reserved | non-reserved | ||
XMLSERIALIZE | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLTABLE | non-reserved (не может быть функцией или типом) | reserved | reserved | |
XMLTEXT | reserved | reserved | ||
XMLVALIDATE | reserved | reserved | ||
YEAR | non-reserved | reserved | reserved | reserved |
YES | non-reserved | non-reserved | non-reserved | |
ZONE | non-reserved | non-reserved | non-reserved | reserved |