ANSI SQLの予約語一覧が見つけられなかったのでまとめてみた。
予約語(reserved word)は SQL overview の各バージョンの文法定義を参考にした。ただし、SQL:1999のみ BNF Grammar for ISO/IEC 9075:1999 - Database Language SQL (SQL-99) を参考に ISO 9075:1999/Cor.1:2000(E) の修正を取り入れた。また、 sql-2011-psm-grammar.html に挙げられているPSMの予約語は一覧から除いた。
ところでANSI SQLでは予約語はキーワード(keyword)という構文要素の一部であり、キーワードは予約語と非予約語(non-reserved word)に分けられている。つまり、次のようになっている。
<keyword> ::= <reserved word>
| <non-reserved word>
ANSI SQLではあるバージョンでは予約語であるものが、別のバージョンでは非予約語とされている場合がある。下表では予約語を○、非予約語なキーワードを●で示した。
2016 | 2011 | 2008 | 2003 | 1999 | 92 | |
---|---|---|---|---|---|---|
ABS | ○ | ○ | ○ | ○ | ● | |
ABSOLUTE | ● | ● | ● | ● | ○ | ○ |
ACOS | ○ | |||||
ACTION | ● | ● | ● | ● | ○ | ○ |
ADD | ● | ● | ● | ● | ○ | ○ |
AFTER | ● | ● | ● | ● | ○ | |
ALL | ○ | ○ | ○ | ○ | ○ | ○ |
ALLOCATE | ○ | ○ | ○ | ○ | ○ | ○ |
ALTER | ○ | ○ | ○ | ○ | ○ | ○ |
AND | ○ | ○ | ○ | ○ | ○ | ○ |
ANY | ○ | ○ | ○ | ○ | ○ | ○ |
ARE | ○ | ○ | ○ | ○ | ○ | ○ |
ARRAY | ○ | ○ | ○ | ○ | ○ | |
ARRAY_AGG | ○ | ○ | ||||
ARRAY_MAX_CARDINALITY | ○ | ○ | ||||
AS | ○ | ○ | ○ | ○ | ○ | ○ |
ASC | ● | ● | ● | ● | ○ | ○ |
ASENSITIVE | ○ | ○ | ○ | ○ | ● | |
ASIN | ○ | |||||
ASSERTION | ● | ● | ● | ● | ○ | ○ |
ASYMMETRIC | ○ | ○ | ○ | ○ | ● | |
AT | ○ | ○ | ○ | ○ | ○ | ○ |
ATAN | ○ | |||||
ATOMIC | ○ | ○ | ○ | ○ | ● | |
AUTHORIZATION | ○ | ○ | ○ | ○ | ○ | ○ |
AVG | ○ | ○ | ○ | ○ | ● | ○ |
BEFORE | ● | ● | ● | ● | ○ | |
BEGIN | ○ | ○ | ○ | ○ | ○ | ○ |
BEGIN_FRAME | ○ | ○ | ||||
BEGIN_PARTITION | ○ | ○ | ||||
BETWEEN | ○ | ○ | ○ | ○ | ○ | ○ |
BIGINT | ○ | ○ | ○ | ○ | ||
BINARY | ○ | ○ | ○ | ○ | ○ | |
BIT | ○ | ○ | ||||
BIT_LENGTH | ● | ○ | ||||
BLOB | ○ | ○ | ○ | ○ | ○ | |
BOOLEAN | ○ | ○ | ○ | ○ | ○ | |
BOTH | ○ | ○ | ○ | ○ | ○ | ○ |
BREADTH | ● | ● | ● | ● | ○ | |
BY | ○ | ○ | ○ | ○ | ○ | ○ |
CALL | ○ | ○ | ○ | ○ | ○ | |
CALLED | ○ | ○ | ○ | ○ | ● | |
CARDINALITY | ○ | ○ | ○ | ○ | ● | |
CASCADE | ● | ● | ● | ● | ○ | ○ |
CASCADED | ○ | ○ | ○ | ○ | ○ | ○ |
CASE | ○ | ○ | ○ | ○ | ○ | ○ |
CAST | ○ | ○ | ○ | ○ | ○ | ○ |
CATALOG | ● | ● | ● | ● | ○ | ○ |
CEIL | ○ | ○ | ○ | ○ | ||
CEILING | ○ | ○ | ○ | ○ | ||
CHAR | ○ | ○ | ○ | ○ | ○ | ○ |
CHARACTER | ○ | ○ | ○ | ○ | ○ | ○ |
CHARACTER_LENGTH | ○ | ○ | ○ | ○ | ● | ○ |
CHAR_LENGTH | ○ | ○ | ○ | ○ | ● | ○ |
CHECK | ○ | ○ | ○ | ○ | ○ | ○ |
CLASSIFIER | ○ | |||||
CLOB | ○ | ○ | ○ | ○ | ○ | |
CLOSE | ○ | ○ | ○ | ○ | ○ | ○ |
COALESCE | ○ | ○ | ○ | ○ | ● | ○ |
COLLATE | ○ | ○ | ○ | ○ | ○ | ○ |
COLLATION | ● | ● | ● | ● | ○ | ○ |
COLLECT | ○ | ○ | ○ | ○ | ||
COLUMN | ○ | ○ | ○ | ○ | ○ | ○ |
COMMIT | ○ | ○ | ○ | ○ | ○ | ○ |
CONDITION | ○ | ○ | ○ | ○ | ○ | |
CONNECT | ○ | ○ | ○ | ○ | ○ | ○ |
CONNECTION | ● | ● | ● | ● | ○ | ○ |
CONSTRAINT | ○ | ○ | ○ | ○ | ○ | ○ |
CONSTRAINTS | ● | ● | ● | ● | ○ | ○ |
CONSTRUCTOR | ● | ● | ● | ● | ○ | |
CONTAINS | ○ | ○ | ● | ● | ● | |
CONTINUE | ● | ● | ● | ● | ○ | ○ |
CONVERT | ○ | ○ | ○ | ○ | ● | ○ |
COPY | ○ | |||||
CORR | ○ | ○ | ○ | ○ | ||
CORRESPONDING | ○ | ○ | ○ | ○ | ○ | ○ |
COS | ○ | |||||
COSH | ○ | |||||
COUNT | ○ | ○ | ○ | ○ | ● | ○ |
COVAR_POP | ○ | ○ | ○ | ○ | ||
COVAR_SAMP | ○ | ○ | ○ | ○ | ||
CREATE | ○ | ○ | ○ | ○ | ○ | ○ |
CROSS | ○ | ○ | ○ | ○ | ○ | ○ |
CUBE | ○ | ○ | ○ | ○ | ○ | |
CUME_DIST | ○ | ○ | ○ | ○ | ||
CURRENT | ○ | ○ | ○ | ○ | ○ | ○ |
CURRENT_CATALOG | ○ | ○ | ○ | |||
CURRENT_DATE | ○ | ○ | ○ | ○ | ○ | ○ |
CURRENT_DEFAULT_TRANSFORM_GROUP | ○ | ○ | ○ | ○ | ○ | |
CURRENT_PATH | ○ | ○ | ○ | ○ | ○ | |
CURRENT_ROLE | ○ | ○ | ○ | ○ | ○ | |
CURRENT_ROW | ○ | ○ | ||||
CURRENT_SCHEMA | ○ | ○ | ○ | |||
CURRENT_TIME | ○ | ○ | ○ | ○ | ○ | ○ |
CURRENT_TIMESTAMP | ○ | ○ | ○ | ○ | ○ | ○ |
CURRENT_TRANSFORM_GROUP_FOR_TYPE | ○ | ○ | ○ | ○ | ○ | |
CURRENT_USER | ○ | ○ | ○ | ○ | ○ | ○ |
CURSOR | ○ | ○ | ○ | ○ | ○ | ○ |
CYCLE | ○ | ○ | ○ | ○ | ○ | |
DATA | ● | ● | ● | ● | ○ | ● |
DATE | ○ | ○ | ○ | ○ | ○ | ○ |
DAY | ○ | ○ | ○ | ○ | ○ | ○ |
DEALLOCATE | ○ | ○ | ○ | ○ | ○ | ○ |
DEC | ○ | ○ | ○ | ○ | ○ | ○ |
DECFLOAT | ○ | |||||
DECIMAL | ○ | ○ | ○ | ○ | ○ | ○ |
DECLARE | ○ | ○ | ○ | ○ | ○ | ○ |
DEFAULT | ○ | ○ | ○ | ○ | ○ | ○ |
DEFERRABLE | ● | ● | ● | ● | ○ | ○ |
DEFERRED | ● | ● | ● | ● | ○ | ○ |
DEFINE | ○ | |||||
DELETE | ○ | ○ | ○ | ○ | ○ | ○ |
DENSE_RANK | ○ | ○ | ○ | ○ | ||
DEPTH | ● | ● | ● | ● | ○ | |
DEREF | ○ | ○ | ○ | ○ | ○ | |
DESC | ● | ● | ● | ● | ○ | ○ |
DESCRIBE | ○ | ○ | ○ | ○ | ○ | ○ |
DESCRIPTOR | ● | ● | ● | ● | ○ | ○ |
DETERMINISTIC | ○ | ○ | ○ | ○ | ○ | |
DIAGNOSTICS | ● | ● | ● | ● | ○ | ○ |
DISCONNECT | ○ | ○ | ○ | ○ | ○ | ○ |
DISTINCT | ○ | ○ | ○ | ○ | ○ | ○ |
DOMAIN | ● | ● | ● | ● | ○ | ○ |
DOUBLE | ○ | ○ | ○ | ○ | ○ | ○ |
DROP | ○ | ○ | ○ | ○ | ○ | ○ |
DYNAMIC | ○ | ○ | ○ | ○ | ○ | |
EACH | ○ | ○ | ○ | ○ | ○ | |
ELEMENT | ○ | ○ | ○ | ○ | ||
ELSE | ○ | ○ | ○ | ○ | ○ | ○ |
EMPTY | ○ | |||||
END | ○ | ○ | ○ | ○ | ○ | ○ |
END-EXEC | ○ | ○ | ○ | ○ | ○ | ○ |
END_FRAME | ○ | ○ | ||||
END_PARTITION | ○ | ○ | ||||
EQUALS | ○ | ○ | ● | ● | ○ | |
ESCAPE | ○ | ○ | ○ | ○ | ○ | ○ |
EVERY | ○ | ○ | ○ | ○ | ● | |
EXCEPT | ○ | ○ | ○ | ○ | ○ | ○ |
EXCEPTION | ● | ○ | ○ | |||
EXEC | ○ | ○ | ○ | ○ | ○ | ○ |
EXECUTE | ○ | ○ | ○ | ○ | ○ | ○ |
EXISTS | ○ | ○ | ○ | ○ | ○ | ○ |
EXIT | ○ | |||||
EXP | ○ | ○ | ○ | ○ | ||
EXTERNAL | ○ | ○ | ○ | ○ | ○ | ○ |
EXTRACT | ○ | ○ | ○ | ○ | ● | ○ |
FALSE | ○ | ○ | ○ | ○ | ○ | ○ |
FETCH | ○ | ○ | ○ | ○ | ○ | ○ |
FILTER | ○ | ○ | ○ | ○ | ||
FIRST | ● | ● | ● | ● | ○ | ○ |
FIRST_VALUE | ○ | ○ | ||||
FLOAT | ○ | ○ | ○ | ○ | ○ | ○ |
FLOOR | ○ | ○ | ○ | ○ | ||
FOR | ○ | ○ | ○ | ○ | ○ | ○ |
FOREIGN | ○ | ○ | ○ | ○ | ○ | ○ |
FOUND | ● | ● | ● | ● | ○ | ○ |
FRAME_ROW | ○ | ○ | ||||
FREE | ○ | ○ | ○ | ○ | ○ | |
FROM | ○ | ○ | ○ | ○ | ○ | ○ |
FULL | ○ | ○ | ○ | ○ | ○ | ○ |
FUNCTION | ○ | ○ | ○ | ○ | ○ | |
FUSION | ○ | ○ | ○ | ○ | ||
GENERAL | ● | ● | ● | ● | ○ | |
GET | ○ | ○ | ○ | ○ | ○ | ○ |
GLOBAL | ○ | ○ | ○ | ○ | ○ | ○ |
GO | ● | ● | ● | ● | ○ | ○ |
GOTO | ● | ● | ● | ● | ○ | ○ |
GRANT | ○ | ○ | ○ | ○ | ○ | ○ |
GROUP | ○ | ○ | ○ | ○ | ○ | ○ |
GROUPING | ○ | ○ | ○ | ○ | ○ | |
GROUPS | ○ | ○ | ||||
HANDLE | ○ | |||||
HAVING | ○ | ○ | ○ | ○ | ○ | ○ |
HOLD | ○ | ○ | ○ | ○ | ○ | |
HOUR | ○ | ○ | ○ | ○ | ○ | ○ |
IDENTITY | ○ | ○ | ○ | ○ | ○ | ○ |
IMMEDIATE | ● | ● | ● | ● | ○ | ○ |
IN | ○ | ○ | ○ | ○ | ○ | ○ |
INDICATOR | ○ | ○ | ○ | ○ | ○ | ○ |
INITIAL | ○ | |||||
INITIALLY | ● | ● | ● | ● | ○ | ○ |
INNER | ○ | ○ | ○ | ○ | ○ | ○ |
INOUT | ○ | ○ | ○ | ○ | ○ | |
INPUT | ● | ● | ● | ● | ○ | ○ |
INSENSITIVE | ○ | ○ | ○ | ○ | ● | ○ |
INSERT | ○ | ○ | ○ | ○ | ○ | ○ |
INT | ○ | ○ | ○ | ○ | ○ | ○ |
INTEGER | ○ | ○ | ○ | ○ | ○ | ○ |
INTERSECT | ○ | ○ | ○ | ○ | ○ | ○ |
INTERSECTION | ○ | ○ | ○ | ○ | ||
INTERVAL | ○ | ○ | ○ | ○ | ○ | ○ |
INTO | ○ | ○ | ○ | ○ | ○ | ○ |
IS | ○ | ○ | ○ | ○ | ○ | ○ |
ISOLATION | ● | ● | ● | ● | ○ | ○ |
JOIN | ○ | ○ | ○ | ○ | ○ | ○ |
JSON_ARRAY | ○ | |||||
JSON_ARRAYAGG | ○ | |||||
JSON_EXISTS | ○ | |||||
JSON_OBJECT | ○ | |||||
JSON_OBJECTAGG | ○ | |||||
JSON_QUERY | ○ | |||||
JSON_TABLE | ○ | |||||
JSON_TABLE_PRIMITIVE | ○ | |||||
JSON_VALUE | ○ | |||||
KEY | ● | ● | ● | ● | ○ | ○ |
LAG | ○ | ○ | ||||
LANGUAGE | ○ | ○ | ○ | ○ | ○ | ○ |
LARGE | ○ | ○ | ○ | ○ | ○ | |
LAST | ● | ● | ● | ● | ○ | ○ |
LAST_VALUE | ○ | ○ | ||||
LATERAL | ○ | ○ | ○ | ○ | ○ | |
LEAD | ○ | ○ | ||||
LEADING | ○ | ○ | ○ | ○ | ○ | ○ |
LEFT | ○ | ○ | ○ | ○ | ○ | ○ |
LEVEL | ● | ● | ● | ● | ○ | ○ |
LIKE | ○ | ○ | ○ | ○ | ○ | ○ |
LIKE_REGEX | ○ | ○ | ○ | |||
LISTAGG | ○ | |||||
LN | ○ | ○ | ○ | ○ | ||
LOCAL | ○ | ○ | ○ | ○ | ○ | ○ |
LOCALTIME | ○ | ○ | ○ | ○ | ○ | |
LOCALTIMESTAMP | ○ | ○ | ○ | ○ | ○ | |
LOCATOR | ● | ● | ● | ● | ○ | |
LOG | ○ | |||||
LOG10 | ○ | |||||
LOWER | ○ | ○ | ○ | ○ | ● | ○ |
MAP | ● | ● | ● | ● | ○ | |
MATCH | ○ | ○ | ○ | ○ | ○ | ○ |
MATCHES | ○ | |||||
MATCH_NUMBER | ○ | |||||
MATCH_RECOGNIZE | ○ | |||||
MAX | ○ | ○ | ○ | ○ | ● | ○ |
MEMBER | ○ | ○ | ○ | ○ | ||
MERGE | ○ | ○ | ○ | ○ | ||
METHOD | ○ | ○ | ○ | ○ | ○ | |
MIN | ○ | ○ | ○ | ○ | ● | ○ |
MINUTE | ○ | ○ | ○ | ○ | ○ | ○ |
MOD | ○ | ○ | ○ | ○ | ● | |
MODIFIES | ○ | ○ | ○ | ○ | ○ | |
MODULE | ○ | ○ | ○ | ○ | ○ | ○ |
MONTH | ○ | ○ | ○ | ○ | ○ | ○ |
MULTISET | ○ | ○ | ○ | ○ | ||
NAMES | ● | ● | ● | ● | ○ | ○ |
NATIONAL | ○ | ○ | ○ | ○ | ○ | ○ |
NATURAL | ○ | ○ | ○ | ○ | ○ | ○ |
NCHAR | ○ | ○ | ○ | ○ | ○ | ○ |
NCLOB | ○ | ○ | ○ | ○ | ○ | |
NESTING | ● | ● | ● | ● | ○ | |
NEW | ○ | ○ | ○ | ○ | ○ | |
NEXT | ● | ● | ● | ● | ○ | ○ |
NO | ○ | ○ | ○ | ○ | ○ | ○ |
NONE | ○ | ○ | ○ | ○ | ○ | |
NORMALIZE | ○ | ○ | ○ | ○ | ||
NOT | ○ | ○ | ○ | ○ | ○ | ○ |
NTH_VALUE | ○ | ○ | ||||
NTILE | ○ | ○ | ||||
NULL | ○ | ○ | ○ | ○ | ○ | ○ |
NULLIF | ○ | ○ | ○ | ○ | ● | ○ |
NUMERIC | ○ | ○ | ○ | ○ | ○ | ○ |
OBJECT | ● | ● | ● | ● | ○ | |
OCCURRENCES_REGEX | ○ | ○ | ○ | |||
OCTET_LENGTH | ○ | ○ | ○ | ○ | ● | ○ |
OF | ○ | ○ | ○ | ○ | ○ | ○ |
OFFSET | ○ | ○ | ||||
OLD | ○ | ○ | ○ | ○ | ○ | |
OMIT | ○ | |||||
ON | ○ | ○ | ○ | ○ | ○ | ○ |
ONE | ○ | |||||
ONLY | ○ | ○ | ○ | ○ | ○ | ○ |
OPEN | ○ | ○ | ○ | ○ | ○ | ○ |
OPTION | ● | ● | ● | ● | ○ | ○ |
OR | ○ | ○ | ○ | ○ | ○ | ○ |
ORDER | ○ | ○ | ○ | ○ | ○ | ○ |
ORDINALITY | ● | ● | ● | ● | ○ | |
OUT | ○ | ○ | ○ | ○ | ○ | |
OUTER | ○ | ○ | ○ | ○ | ○ | ○ |
OUTPUT | ● | ● | ● | ● | ○ | ○ |
OVER | ○ | ○ | ○ | ○ | ||
OVERLAPS | ○ | ○ | ○ | ○ | ○ | ○ |
OVERLAY | ○ | ○ | ○ | ○ | ● | |
PAD | ● | ● | ● | ● | ○ | ○ |
PARAMETER | ○ | ○ | ○ | ○ | ○ | |
PARTIAL | ● | ● | ● | ● | ○ | ○ |
PARTITION | ○ | ○ | ○ | ○ | ||
PATH | ● | ● | ● | ● | ○ | |
PATTERN | ○ | |||||
PER | ○ | |||||
PERCENT | ○ | ○ | ||||
PERCENTILE_CONT | ○ | ○ | ○ | ○ | ||
PERCENTILE_DISC | ○ | ○ | ○ | ○ | ||
PERCENT_RANK | ○ | ○ | ○ | ○ | ||
PERIOD | ○ | ○ | ||||
PORTION | ○ | ○ | ||||
POSITION | ○ | ○ | ○ | ○ | ● | ○ |
POSITION_REGEX | ○ | ○ | ○ | |||
POWER | ○ | ○ | ○ | ○ | ||
PRECEDES | ○ | ○ | ||||
PRECISION | ○ | ○ | ○ | ○ | ○ | ○ |
PREPARE | ○ | ○ | ○ | ○ | ○ | ○ |
PRESERVE | ● | ● | ● | ● | ○ | ○ |
PRIMARY | ○ | ○ | ○ | ○ | ○ | ○ |
PRIOR | ● | ● | ● | ● | ○ | ○ |
PRIVILEGES | ● | ● | ● | ● | ○ | ○ |
PROCEDURE | ○ | ○ | ○ | ○ | ○ | ○ |
PTF | ○ | |||||
PUBLIC | ● | ● | ● | ● | ○ | ○ |
RANGE | ○ | ○ | ○ | ○ | ||
RANK | ○ | ○ | ○ | ○ | ||
READ | ● | ● | ● | ● | ○ | ○ |
READS | ○ | ○ | ○ | ○ | ○ | |
REAL | ○ | ○ | ○ | ○ | ○ | ○ |
RECURSIVE | ○ | ○ | ○ | ○ | ○ | |
REDO | ○ | |||||
REF | ○ | ○ | ○ | ○ | ○ | |
REFERENCES | ○ | ○ | ○ | ○ | ○ | ○ |
REFERENCING | ○ | ○ | ○ | ○ | ○ | |
REGR_AVGX | ○ | ○ | ○ | ○ | ||
REGR_AVGY | ○ | ○ | ○ | ○ | ||
REGR_COUNT | ○ | ○ | ○ | ○ | ||
REGR_INTERCEPT | ○ | ○ | ○ | ○ | ||
REGR_R2 | ○ | ○ | ○ | ○ | ||
REGR_SLOPE | ○ | ○ | ○ | ○ | ||
REGR_SXX | ○ | ○ | ○ | ○ | ||
REGR_SXY | ○ | ○ | ○ | ○ | ||
REGR_SYY | ○ | ○ | ○ | ○ | ||
RELATIVE | ● | ● | ● | ● | ○ | ○ |
RELEASE | ○ | ○ | ○ | ○ | ○ | |
RESTRICT | ● | ● | ● | ● | ○ | ○ |
RESULT | ○ | ○ | ○ | ○ | ○ | |
RETURN | ○ | ○ | ○ | ○ | ○ | |
RETURNS | ○ | ○ | ○ | ○ | ○ | |
REVOKE | ○ | ○ | ○ | ○ | ○ | ○ |
RIGHT | ○ | ○ | ○ | ○ | ○ | ○ |
ROLE | ● | ● | ● | ● | ○ | |
ROLLBACK | ○ | ○ | ○ | ○ | ○ | ○ |
ROLLUP | ○ | ○ | ○ | ○ | ○ | |
ROUTINE | ● | ● | ● | ● | ○ | |
ROW | ○ | ○ | ○ | ○ | ○ | |
ROWS | ○ | ○ | ○ | ○ | ○ | ○ |
ROW_NUMBER | ○ | ○ | ○ | ○ | ||
RUNNING | ○ | |||||
SAVEPOINT | ○ | ○ | ○ | ○ | ○ | |
SCHEMA | ● | ● | ● | ● | ○ | ○ |
SCOPE | ○ | ○ | ○ | ○ | ● | |
SCROLL | ○ | ○ | ○ | ○ | ○ | ○ |
SEARCH | ○ | ○ | ○ | ○ | ○ | |
SECOND | ○ | ○ | ○ | ○ | ○ | ○ |
SECTION | ● | ● | ● | ● | ○ | ○ |
SEEK | ○ | |||||
SELECT | ○ | ○ | ○ | ○ | ○ | ○ |
SENSITIVE | ○ | ○ | ○ | ○ | ● | |
SESSION | ● | ● | ● | ● | ○ | ○ |
SESSION_USER | ○ | ○ | ○ | ○ | ○ | ○ |
SET | ○ | ○ | ○ | ○ | ○ | ○ |
SETS | ● | ● | ● | ● | ○ | |
SHOW | ○ | |||||
SIMILAR | ○ | ○ | ○ | ○ | ○ | |
SIN | ○ | |||||
SINH | ○ | |||||
SIZE | ● | ● | ● | ● | ○ | ○ |
SKIP | ○ | |||||
SMALLINT | ○ | ○ | ○ | ○ | ○ | ○ |
SOME | ○ | ○ | ○ | ○ | ○ | ○ |
SPACE | ● | ● | ● | ● | ○ | ○ |
SPECIFIC | ○ | ○ | ○ | ○ | ○ | |
SPECIFICTYPE | ○ | ○ | ○ | ○ | ○ | |
SQL | ○ | ○ | ○ | ○ | ○ | ○ |
SQLCODE | ○ | |||||
SQLERROR | ○ | |||||
SQLEXCEPTION | ○ | ○ | ○ | ○ | ○ | |
SQLSTATE | ○ | ○ | ○ | ○ | ○ | ○ |
SQLWARNING | ○ | ○ | ○ | ○ | ○ | |
SQRT | ○ | ○ | ○ | ○ | ||
START | ○ | ○ | ○ | ○ | ○ | |
STATE | ● | ● | ● | ● | ○ | |
STATIC | ○ | ○ | ○ | ○ | ○ | |
STDDEV_POP | ○ | ○ | ○ | ○ | ||
STDDEV_SAMP | ○ | ○ | ○ | ○ | ||
SUBMULTISET | ○ | ○ | ○ | ○ | ||
SUBSET | ○ | |||||
SUBSTRING | ○ | ○ | ○ | ○ | ● | ○ |
SUBSTRING_REGEX | ○ | ○ | ○ | |||
SUCCEEDS | ○ | ○ | ||||
SUM | ○ | ○ | ○ | ○ | ● | ○ |
SYMMETRIC | ○ | ○ | ○ | ○ | ● | |
SYSTEM | ○ | ○ | ○ | ○ | ● | |
SYSTEM_TIME | ○ | ○ | ||||
SYSTEM_USER | ○ | ○ | ○ | ○ | ○ | ○ |
TABLE | ○ | ○ | ○ | ○ | ○ | ○ |
TABLESAMPLE | ○ | ○ | ○ | ○ | ||
TAN | ○ | |||||
TANH | ○ | |||||
TEMPORARY | ● | ● | ● | ● | ○ | ○ |
THEN | ○ | ○ | ○ | ○ | ○ | ○ |
TIME | ○ | ○ | ○ | ○ | ○ | ○ |
TIMESTAMP | ○ | ○ | ○ | ○ | ○ | ○ |
TIMEZONE_HOUR | ○ | ○ | ○ | ○ | ○ | ○ |
TIMEZONE_MINUTE | ○ | ○ | ○ | ○ | ○ | ○ |
TO | ○ | ○ | ○ | ○ | ○ | ○ |
TRAILING | ○ | ○ | ○ | ○ | ○ | ○ |
TRANSACTION | ● | ● | ● | ● | ○ | ○ |
TRANSLATE | ○ | ○ | ○ | ○ | ● | ○ |
TRANSLATE_REGEX | ○ | ○ | ○ | |||
TRANSLATION | ○ | ○ | ○ | ○ | ○ | ○ |
TREAT | ○ | ○ | ○ | ○ | ○ | |
TRIGGER | ○ | ○ | ○ | ○ | ○ | |
TRIM | ○ | ○ | ○ | ○ | ● | ○ |
TRIM_ARRAY | ○ | ○ | ||||
TRUE | ○ | ○ | ○ | ○ | ○ | ○ |
TRUNCATE | ○ | ○ | ||||
UESCAPE | ○ | ○ | ○ | ○ | ||
UNDER | ● | ● | ● | ● | ○ | |
UNDO | ○ | |||||
UNION | ○ | ○ | ○ | ○ | ○ | ○ |
UNIQUE | ○ | ○ | ○ | ○ | ○ | ○ |
UNKNOWN | ○ | ○ | ○ | ○ | ○ | ○ |
UNNEST | ○ | ○ | ○ | ○ | ○ | |
UPDATE | ○ | ○ | ○ | ○ | ○ | ○ |
UPPER | ○ | ○ | ○ | ○ | ● | ○ |
USAGE | ● | ● | ● | ● | ○ | ○ |
USER | ○ | ○ | ○ | ○ | ○ | ○ |
USING | ○ | ○ | ○ | ○ | ○ | ○ |
VALUE | ○ | ○ | ○ | ○ | ○ | ○ |
VALUES | ○ | ○ | ○ | ○ | ○ | ○ |
VALUE_OF | ○ | ○ | ||||
VARBINARY | ○ | ○ | ○ | |||
VARCHAR | ○ | ○ | ○ | ○ | ○ | ○ |
VARYING | ○ | ○ | ○ | ○ | ○ | ○ |
VAR_POP | ○ | ○ | ○ | ○ | ||
VAR_SAMP | ○ | ○ | ○ | ○ | ||
VERSIONING | ○ | ○ | ||||
VIEW | ● | ● | ● | ● | ○ | ○ |
WHEN | ○ | ○ | ○ | ○ | ○ | ○ |
WHENEVER | ○ | ○ | ○ | ○ | ○ | ○ |
WHERE | ○ | ○ | ○ | ○ | ○ | ○ |
WIDTH_BUCKET | ○ | ○ | ○ | ○ | ||
WINDOW | ○ | ○ | ○ | ○ | ||
WITH | ○ | ○ | ○ | ○ | ○ | ○ |
WITHIN | ○ | ○ | ○ | ○ | ||
WITHOUT | ○ | ○ | ○ | ○ | ○ | |
WORK | ● | ● | ● | ● | ○ | ○ |
WRITE | ● | ● | ● | ● | ○ | ○ |
YEAR | ○ | ○ | ○ | ○ | ○ | ○ |
ZONE | ● | ● | ● | ● | ○ | ○ |