-
Notifications
You must be signed in to change notification settings - Fork 678
SQL keywords
Andrey Gershun edited this page May 24, 2015
·
13 revisions
The list of keywords used in AlaSQL (based on the table from here).
Keyword | SQL-92 | SQL-99 | SQL-2003 | SQL-2008 | SQL-2011 | AlaSQL |
[ABS](Abs) | √ | √ | √ | |||
ABSOLUTE | √ | √ | ||||
ACTION | √ | √ | ||||
ADD | √ | √ | √ | |||
AFTER | √ | √ | ||||
ALL | √ | √ | √ | √ | √ | √ |
ALLOCATE | √ | √ | √ | √ | √ | |
ALTER | √ | √ | √ | √ | √ | √ |
[AND](And) | √ | √ | √ | √ | √ | √ |
[ANY](Any) | √ | √ | √ | √ | √ | √ |
ARE | √ | √ | √ | √ | √ | |
ARRAY | √ | √ | √ | √ | ||
ARRAY_AGG | √ | √ | ||||
ARRAY_MAX_CARDINALITY | √ | |||||
AS | √ | √ | √ | √ | √ | √ |
[ASC](Asc) | √ | √ | √ | |||
ASENSITIVE | √ | √ | √ | √ | ||
ASSERTION | √ | |||||
ASYMMETRIC | √ | √ | √ | √ | ||
AT | √ | √ | √ | √ | √ | √ |
ATOMIC | √ | √ | √ | √ | ||
AUTHORIZATION | √ | √ | √ | √ | √ | |
[AVG](Avg) | √ | √ | √ | √ | ||
BEFORE | √ | |||||
[BEGIN](Begin) | √ | √ | √ | √ | √ | √ |
BEGIN_FRAME | √ | |||||
BEGIN_PARTITION | √ | |||||
BETWEEN | √ | √ | √ | √ | √ | √ |
BIGINT | √ | √ | √ | |||
BINARY | √ | √ | √ | √ | ||
BIT | √ | √ | ||||
BIT_LENGTH | √ | |||||
BLOB | √ | √ | √ | √ | ||
BOOLEAN | √ | √ | √ | √ | ||
BOTH | √ | √ | √ | √ | √ | |
BREADTH | √ | |||||
BY | √ | √ | √ | √ | √ | √ |
CALL | √ | √ | √ | √ | √ | |
CALLED | √ | √ | √ | |||
CARDINALITY | √ | √ | ||||
CASCADE | √ | √ | √ | √ | √ | |
CASCADED | √ | √ | √ | √ | √ | |
[CASE](Case) | √ | √ | √ | √ | √ | √ |
[CAST](Cast) | √ | √ | √ | √ | √ | √ |
CATALOG | √ | √ | ||||
CEIL | √ | √ | ||||
CEILING | √ | √ | ||||
CHAR | √ | √ | √ | √ | √ | |
CHAR_LENGTH | √ | √ | √ | |||
CHARACTER | √ | √ | √ | √ | √ | |
CHARACTER_LENGTH | √ | √ | √ | |||
[CHECK](Check) | √ | √ | √ | √ | √ | √ |
CLOB | √ | √ | √ | √ | ||
CLOSE | √ | √ | √ | √ | √ | √ |
COALESCE | √ | √ | √ | √ | ||
COLLATE | √ | √ | √ | √ | √ | |
COLLATION | √ | √ | ||||
COLLECT | √ | √ | ||||
COLUMN | √ | √ | √ | √ | √ | √ |
COMMIT | √ | √ | √ | √ | √ | √ |
CONDITION | √ | √ | √ | √ | √ | |
CONNECT | √ | √ | √ | √ | √ | |
CONNECTION | √ | √ | ||||
[CONSTRAINT](Constraint) | √ | √ | √ | √ | √ | √ |
CONSTRAINTS | √ | √ | √ | |||
CONSTRUCTOR | √ | |||||
[CONTAINS](Contains) | √ | |||||
CONTINUE | √ | √ | ||||
CONVERT | √ | √ | √ | |||
CORR | √ | √ | ||||
[CORRESPONDING](Corresponding) | √ | √ | √ | √ | √ | √ |
[COUNT](Count) | √ | √ | √ | |||
COVAR_POP | √ | √ | ||||
COVAR_SAMP | √ | √ | ||||
CREATE | √ | √ | √ | √ | √ | √ |
[CROSS](Cross) | √ | √ | √ | √ | √ | √ |
[CUBE](Cube) | √ | √ | √ | √ | √ | |
CUME_DIST | √ | √ | ||||
CURRENT | √ | √ | √ | √ | √ | |
CURRENT_CATALOG | √ | √ | ||||
CURRENT_DATE | √ | √ | √ | √ | √ | |
CURRENT_DEFAULT _TRANSFORM_GROUP | √ | √ | √ | √ | ||
CURRENT_PATH | √ | √ | √ | √ | √ | |
CURRENT_ROLE | √ | √ | √ | √ | ||
CURRENT_ROW | √ | |||||
CURRENT_SCHEMA | √ | √ | ||||
[CURRENT_TIME](Current_Time) | √ | √ | √ | √ | √ | |
CURRENT_TIMESTAMP | √ | √ | √ | √ | √ | √ |
CURRENT_TRANSFORM _GROUP_FOR_TYPE | √ | √ | √ | √ | ||
CURRENT_USER | √ | √ | √ | √ | √ | |
CURSOR | √ | √ | √ | √ | √ | |
CYCLE | √ | √ | √ | √ | ||
DATA | √ | |||||
[DATE](Date) | √ | √ | √ | √ | √ | √ |
[DAY](Day) | √ | √ | √ | √ | √ | √ |
DEALLOCATE | √ | √ | √ | √ | √ | |
DEC | √ | √ | √ | √ | √ | |
DECIMAL | √ | √ | √ | √ | √ | |
[DECLARE](Declare) | √ | √ | √ | √ | √ | √ |
[DEFAULT](Default) | √ | √ | √ | √ | √ | √ |
DEFERRABLE | √ | √ | ||||
DEFERRED | √ | √ | ||||
[DELETE](Delete) | √ | √ | √ | √ | √ | √ |
DENSE_RANK | √ | √ | ||||
DEPTH | √ | |||||
DEREF | √ | √ | √ | √ | ||
[DESC](Desc) | √ | √ | √ | |||
DESCRIBE | √ | √ | √ | √ | √ | |
DESCRIPTOR | √ | √ | ||||
DETERMINISTIC | √ | √ | √ | √ | √ | |
DIAGNOSTICS | √ | √ | ||||
DISCONNECT | √ | √ | √ | √ | √ | |
[DISTINCT](Distinct) | √ | √ | √ | √ | √ | √ |
DO | √ | √ | √ | √ | √ | |
DOMAIN | √ | √ | ||||
[DOUBLE](Double Precision) | √ | √ | √ | √ | √ | √ |
[DROP](Drop) | √ | √ | √ | √ | √ | √ |
DYNAMIC | √ | √ | √ | √ | ||
EACH | √ | √ | √ | √ | ||
ELEMENT | √ | √ | √ | |||
[ELSE](Else) | √ | √ | √ | √ | √ | √ |
ELSEIF | √ | √ | √ | √ | √ | |
[END](End) | √ | √ | √ | √ | √ | √ |
END_FRAME | √ | |||||
END_PARTITION | √ | |||||
END_EXEC | √ | √ | ||||
EQUALS | √ | |||||
ESCAPE | √ | √ | √ | √ | √ | √ |
EVERY | √ | √ | ||||
[EXCEPT](Except) | √ | √ | √ | √ | √ | √ |
EXCEPTION | √ | √ | ||||
EXEC | √ | √ | √ | √ | √ | |
EXECUTE | √ | √ | √ | √ | √ | √ |
[EXISTS](Exists) | √ | √ | √ | √ | √ | √ |
EXIT | √ | √ | √ | |||
EXTERNAL | √ | √ | √ | √ | √ | |
EXTRACT | √ | √ | √ | |||
[FALSE](False) | √ | √ | √ | √ | √ | √ |
FETCH | √ | √ | √ | √ | √ | |
FILTER | √ | √ | √ | √ | ||
[FIRST](First) | √ | √ | √ | |||
FIRST_VALUE | √ | |||||
FLOAT | √ | √ | √ | √ | √ | |
FOR | √ | √ | √ | √ | √ | |
[FOREIGN](Foreign Key) | √ | √ | √ | √ | √ | √ |
FOUND | √ | √ | ||||
FRAME_ROW | √ | |||||
FREE | √ | √ | √ | √ | ||
[FROM](From) | √ | √ | √ | √ | √ | √ |
FULL | √ | √ | √ | √ | √ | √ |
FUNCTION | √ | √ | √ | √ | √ | |
FUSION | √ | √ | √ | |||
GENERAL | √ | |||||
GET | √ | √ | √ | √ | √ | √ |
GLOBAL | √ | √ | √ | √ | √ | √ |
[GO](Go) | √ | √ | ||||
GOTO | √ | √ | ||||
GRANT | √ | √ | √ | √ | √ | |
[GROUP](Group) | √ | √ | √ | √ | √ | √ |
[GROUPING](Grouping Sets) | √ | √ | √ | √ | √ | |
GROUPS | √ | |||||
HANDLER | √ | √ | √ | √ | √ | |
[HAVING](Having) | √ | √ | √ | √ | √ | √ |
HOLD | √ | √ | √ | √ | ||
[HOUR](Hour) | √ | √ | √ | √ | √ | √ |
[IDENTITY](Identity) | √ | √ | √ | √ | √ | √ |
[IF](If) | √ | √ | √ | √ | √ | √ |
IMMEDIATE | √ | √ | √ | |||
[IN](In) | √ | √ | √ | √ | √ | √ |
INDICATOR | √ | √ | √ | √ | √ | |
INITIALLY | √ | √ | ||||
[INNER](Inner) | √ | √ | √ | √ | √ | √ |
INOUT | √ | √ | √ | √ | √ | |
INPUT | √ | √ | √ | |||
INSENSITIVE | √ | √ | √ | √ | √ | |
[INSERT](Insert) | √ | √ | √ | √ | √ | √ |
INT | √ | √ | √ | √ | √ | |
INTEGER | √ | √ | √ | √ | √ | |
[INTERSECT](Intersect) | √ | √ | √ | √ | √ | √ |
INTERSECTION | √ | √ | ||||
INTERVAL | √ | √ | √ | √ | √ | |
[INTO](Into) | √ | √ | √ | √ | √ | √ |
IS | √ | √ | √ | √ | √ | √ |
ISOLATION | √ | √ | ||||
ITERATE | √ | √ | √ | √ | ||
[JOIN](Join) | √ | √ | √ | √ | √ | √ |
KEY | √ | √ | ||||
LANGUAGE | √ | √ | √ | √ | √ | |
LARGE | √ | √ | √ | √ | ||
[LAST](Last) | √ | √ | ||||
LAST_VALUE | √ | |||||
LATERAL | √ | √ | √ | √ | ||
LEAD | √ | |||||
LEADING | √ | √ | √ | √ | √ | |
LEAVE | √ | √ | √ | √ | √ | |
[LEFT](Left) | √ | √ | √ | √ | √ | √ |
LEVEL | √ | √ | ||||
[LIKE](Like) | √ | √ | √ | √ | √ | √ |
LIKE_REGEX | √ | √ | ||||
LIMIT | √ | |||||
LN | √ | √ | ||||
LOCAL | √ | √ | √ | √ | √ | |
LOCALTIME | √ | √ | √ | √ | ||
LOCALTIMESTAMP | √ | √ | √ | √ | ||
LOCATOR | √ | |||||
LOOP | √ | √ | √ | √ | √ | |
[LOWER](Lower) | √ | √ | √ | |||
MAP | √ | |||||
MATCH | √ | √ | √ | √ | √ | |
[MAX](Max) | √ | √ | √ | √ | ||
MEMBER | √ | √ | √ | |||
MERGE | √ | √ | √ | |||
METHOD | √ | √ | √ | √ | ||
[MIN](Min) | √ | √ | √ | √ | ||
MINUTE | √ | √ | √ | √ | √ | √ |
MOD | √ | √ | ||||
MODIFIES | √ | √ | √ | √ | ||
MODULE | √ | √ | √ | √ | √ | |
MONTH | √ | √ | √ | √ | √ | √ |
MULTISET | √ | √ | √ | |||
NAMES | √ | √ | ||||
NATIONAL | √ | √ | √ | √ | √ | |
[NATURAL](Natural) | √ | √ | √ | √ | √ | √ |
NCHAR | √ | √ | √ | √ | √ | |
NCLOB | √ | √ | √ | √ | ||
[NEW](New) | √ | √ | √ | √ | √ | |
NEXT | √ | √ | ||||
NO | √ | √ | √ | √ | √ | |
NONE | √ | √ | √ | √ | ||
NORMALIZE | √ | √ | ||||
[NOT](Not) | √ | √ | √ | √ | √ | √ |
NTH_VALUE | √ | |||||
NTILE | √ | |||||
[NULL](Null) | √ | √ | √ | √ | √ | √ |
[NULLIF](Null) | √ | √ | √ | √ | ||
NUMERIC | √ | √ | √ | √ | √ | |
OBJECT | √ | |||||
OCTET_LENGTH | √ | √ | √ | |||
OF | √ | √ | √ | √ | √ | √ |
[OFFSET](Offset) | √ | √ | ||||
OLD | √ | √ | √ | √ | ||
ON | √ | √ | √ | √ | √ | √ |
ONLY | √ | √ | √ | √ | √ | |
OPEN | √ | √ | √ | √ | √ | |
OPTION | √ | √ | ||||
[OR](Or) | √ | √ | √ | √ | √ | √ |
[ORDER](Order By) | √ | √ | √ | √ | √ | √ |
ORDINALITY | √ | |||||
OUT | √ | √ | √ | √ | √ | √ |
[OUTER](Outer) | √ | √ | √ | √ | √ | √ |
OUTPUT | √ | √ | √ | |||
OVER | √ | √ | ||||
OVERLAPS | √ | √ | √ | √ | √ | |
OVERLAY | √ | √ | ||||
PAD | √ | √ | ||||
PARAMETER | √ | √ | √ | √ | √ | |
PARTIAL | √ | √ | ||||
PARTITION | √ | √ | √ | √ | ||
PATH | √ | √ | ||||
PERCENT | √ | √ | ||||
PERCENT_RANK | √ | √ | ||||
PERCENTILE_CONT | √ | √ | ||||
PERCENTILE_DISC | √ | √ | ||||
PERIOD | √ | |||||
PORTION | √ | |||||
POSITION | √ | √ | √ | |||
POSITION_REGEX | √ | √ | ||||
POWER | √ | √ | ||||
PRECEDES | √ | |||||
PRECISION | √ | √ | √ | √ | √ | √ |
PREPARE | √ | √ | √ | √ | √ | |
PRESERVE | √ | √ | ||||
[PRIMARY](Primary Key) | √ | √ | √ | √ | √ | √ |
PRIOR | √ | √ | ||||
PRIVILEGES | √ | √ | ||||
PROCEDURE | √ | √ | √ | √ | √ | |
PUBLIC | √ | √ | ||||
[RANGE](Range) | √ | √ | √ | √ | √ | |
RANK | √ | √ | ||||
READ | √ | √ | ||||
READS | √ | √ | √ | √ | ||
REAL | √ | √ | √ | √ | √ | |
RECURSIVE | √ | √ | √ | √ | ||
REF | √ | √ | √ | √ | ||
[REFERENCES](References) | √ | √ | √ | √ | √ | √ |
REFERENCING | √ | √ | √ | √ | ||
REGR_AVGX | √ | √ | ||||
REGR_AVGY | √ | √ | ||||
REGR_COUNT | √ | √ | ||||
REGR_INTERCEPT | √ | √ | ||||
REGR_R2 | √ | √ | ||||
REGR_SLOPE | √ | √ | ||||
REGR_SXX | √ | √ | ||||
REGR_SXYREGR_SYY | √ | √ | ||||
RELATIVE | √ | √ | ||||
RELEASE | √ | √ | √ | √ | ||
REPEAT | √ | √ | √ | √ | √ | |
RESIGNAL | √ | √ | √ | √ | √ | |
RESTRICT | √ | √ | ||||
RESULT | √ | √ | √ | √ | ||
RETURN | √ | √ | √ | √ | √ | √ |
RETURNS | √ | √ | √ | √ | √ | √ |
REVOKE | √ | √ | √ | √ | √ | |
[RIGHT](Right) | √ | √ | √ | √ | √ | √ |
ROLE | √ | |||||
ROLLBACK | √ | √ | √ | √ | √ | √ |
[ROLLUP](Rollup) | √ | √ | √ | √ | √ | |
ROUTINE | √ | √ | ||||
ROW | √ | √ | √ | √ | √ | |
ROW_NUMBER | √ | √ | ||||
ROWS | √ | √ | √ | √ | √ | |
SAVEPOINT | √ | √ | √ | √ | ||
SCHEMA | √ | √ | √ | |||
SCOPE | √ | √ | √ | √ | ||
SCROLL | √ | √ | √ | √ | √ | |
SEARCH | √ | √ | √ | √ | √ | |
SECOND | √ | √ | √ | √ | √ | √ |
SECTION | √ | √ | ||||
SELECT | √ | √ | √ | √ | √ | √ |
SENSITIVE | √ | √ | √ | √ | ||
SESSION | √ | √ | ||||
SESSION_USER | √ | √ | √ | √ | √ | |
[SET](Set) | √ | √ | √ | √ | √ | √ |
[SETS](Grouping Sets) | √ | √ | ||||
SIGNAL | √ | √ | √ | √ | ||
SIMILAR | √ | √ | √ | √ | ||
SIZE | √ | √ | ||||
SMALLINT | √ | √ | √ | √ | √ | |
[SOME](Some) | √ | √ | √ | √ | √ | √ |
SPACE | √ | √ | ||||
SPECIFIC | √ | √ | √ | √ | √ | |
SPECIFICTYPE | √ | √ | √ | √ | ||
SQL | √ | √ | √ | √ | √ | |
SQLCODE | √ | |||||
SQLERROR | √ | |||||
SQLEXCEPTION | √ | √ | √ | √ | √ | |
SQLSTATE | √ | √ | √ | √ | √ | |
SQLWARNING | √ | √ | √ | √ | √ | |
SQRT | √ | √ | ||||
START | √ | √ | √ | √ | ||
STATE | √ | |||||
STATIC | √ | √ | √ | √ | ||
[STDDEV_POP]() | √ | √ | ||||
[STDDEV_SAMP]() | √ | √ | ||||
SUBMULTISET | √ | √ | √ | |||
[SUBSTRING](Substring) | √ | √ | √ | √ | ||
SUBSTRING_REGEX | √ | √ | ||||
SUCCEEDS | √ | |||||
[SUM](Sum) | √ | √ | √ | √ | ||
SYMMETRIC | √ | √ | √ | √ | ||
SYSTEM | √ | √ | √ | √ | ||
SYSTEM_TIME | √ | |||||
SYSTEM_USER | √ | √ | √ | √ | √ | |
[TABLE](Create Table) | √ | √ | √ | √ | √ | √ |
TABLESAMPLE | √ | √ | √ | |||
TEMPORARY | √ | √ | √ | |||
THEN | √ | √ | √ | √ | √ | √ |
TIME | √ | √ | √ | √ | √ | √ |
TIMESTAMP | √ | √ | √ | √ | √ | √ |
TIMEZONE_HOUR | √ | √ | √ | √ | √ | |
TIMEZONE_MINUTE | √ | √ | √ | √ | √ | |
TO | √ | √ | √ | √ | √ | √ |
TRAILING | √ | √ | √ | √ | √ | |
TRANSACTION | √ | √ | ||||
TRANSLATE | √ | √ | √ | |||
TRANSLATE_REGEX | √ | √ | ||||
TRANSLATION | √ | √ | √ | √ | √ | |
TREAT | √ | √ | √ | √ | ||
TRIGGER | √ | √ | √ | √ | ||
TRIM | √ | √ | √ | √ | ||
TRIM_ARRAY | √ | |||||
[TRUE](True) | √ | √ | √ | √ | √ | √ |
TRUNCATE | √ | √ | ||||
UESCAPE | √ | √ | ||||
UNDER | √ | |||||
UNDO | √ | √ | √ | √ | √ | |
[UNION](Union) | √ | √ | √ | √ | √ | √ |
[UNIQUE](Unique) | √ | √ | √ | √ | √ | √ |
UNKNOWN | √ | √ | √ | √ | √ | |
UNNEST | √ | √ | √ | √ | ||
UNTIL | √ | √ | √ | √ | ||
UPDATE | √ | √ | √ | √ | √ | √ |
[UPPER](Upper) | √ | √ | √ | √ | ||
USAGE | √ | √ | ||||
USER | √ | √ | √ | √ | √ | |
[USING](Using) | √ | √ | √ | √ | √ | √ |
VALUE | √ | √ | √ | √ | √ | √ |
VALUES | √ | √ | √ | √ | √ | √ |
VALUE_OF | √ | |||||
VAR_POP | √ | √ | √ | |||
VAR_SAMP | √ | √ | √ | |||
VARBINARY | √ | √ | ||||
VARCHAR | √ | √ | √ | √ | √ | √ |
VARYING | √ | √ | √ | √ | √ | |
VERSIONING | √ | |||||
[VIEW](Create View) | √ | √ | √ | |||
WHEN | √ | √ | √ | √ | √ | √ |
WHENEVER | √ | √ | √ | √ | √ | |
WHERE | √ | √ | √ | √ | √ | √ |
[WHILE](While) | √ | √ | √ | √ | √ | √ |
WIDTH_BUCKET | √ | √ | ||||
WINDOW | √ | √ | √ | √ | ||
[WITH](With) | √ | √ | √ | √ | √ | √ |
WITHIN | √ | √ | √ | √ | ||
WITHOUT | √ | √ | √ | √ | ||
WORK | √ | √ | √ | |||
WRITE | √ | √ | ||||
YEAR | √ | √ | √ | √ | √ | √ |
ZONE | √ | √ |
© 2014-2024, Andrey Gershun & Mathias Rangel Wulff
Please help improve the documentation by opening a PR on the wiki repo