A.2. Reserved Keywords Keyword Usage ADD add set option ALL standard aggregate function , function , query expression body , query term select clause , quantified comparison predicate ALTER alter , alter column options , alter options AND between predicate , boolean term ANY standard aggregate function , quantified comparison predicate ARRAY_AGG ordered aggregate function AS alter , array table , create procedure , option namespace , create table , create trigger , derived column , dynamic data statement , function , loop statement , xml namespace element , object table , select derived column , table subquery , text table , table name , with list element , xml serialize , xml table ASC sort specification ATOMIC compound statement , for each row trigger action BEGIN compound statement , for each row trigger action BETWEEN between predicate BIGDECIMAL data type BIGINT data type BIGINTEGER data type BLOB data type , xml serialize BOOLEAN data type BOTH function BREAK branching statement BY group by clause , order by clause , window specification BYTE data type CALL callable statement , call statement CASE case expression , searched case expression CAST function CHAR function , data type CLOB data type , xml serialize COLUMN alter column options CONSTRAINT create table body CONTINUE branching statement CONVERT function CREATE create procedure , create foreign temp table , create table , create temporary table , create trigger , procedure body definition CROSS cross join DATE data type DAY function DECIMAL data type DECLARE declare statement DEFAULT table element , xml namespace element , object table column , procedure parameter , xml table column DELETE alter , create trigger , delete statement DESC sort specification DISTINCT standard aggregate function , function , query expression body , query term , select clause DOUBLE data type DROP drop option , drop table EACH for each row trigger action ELSE case expression , if statement , searched case expression END case expression , compound statement , for each row trigger action , searched case expression ERROR raise error statement ESCAPE match predicate , text table EXCEPT query expression body EXEC dynamic data statement , call statement EXECUTE dynamic data statement , call statement EXISTS exists predicate FALSE non numeric literal FETCH fetch clause FILTER filter clause FLOAT data type FOR for each row trigger action , function , text aggregate function , xml table column FOREIGN alter options , create procedure , create foreign temp table , create table , foreign key FROM delete statement , from clause , function FULL qualified table FUNCTION create procedure GROUP group by clause HAVING having clause HOUR function IF if statement IMMEDIATE dynamic data statement IN procedure parameter , in predicate INNER qualified table INOUT procedure parameter INSERT alter , create trigger , function , insert statement INTEGER data type INTERSECT query term INTO dynamic data statement , insert statement , into clause IS is null predicate JOIN cross join , qualified table LANGUAGE object table LATERAL table subquery LEADING function LEAVE branching statement LEFT function , qualified table LIKE match predicate LIKE_REGEX like regex predicate LIMIT limit clause LOCAL create temporary table LONG data type LOOP loop statement MAKEDEP option clause , table primary MAKENOTDEP option clause , table primary MERGE insert statement MINUTE function MONTH function NO xml namespace element , text table column , text table NOCACHE option clause NOT between predicate , compound statement , table element , is null predicate , match predicate , boolean factor , procedure parameter , procedure result column , like regex predicate , in predicate , temporary table element NULL table element , is null predicate , non numeric literal , procedure parameter , procedure result column , temporary table element , xml query OBJECT data type OF alter , create trigger OFFSET limit clause ON alter , create foreign temp table , create trigger , loop statement , qualified table , xml query ONLY fetch clause OPTION option clause OPTIONS alter options list , options clause OR boolean value expression ORDER order by clause OUT procedure parameter OUTER qualified table OVER window specification PARAMETER alter column options PARTITION window specification PRIMARY table element , create temporary table , primary key PROCEDURE alter , alter options , create procedure , procedure body definition REAL data type REFERENCES foreign key RETURN assignment statement , return statement , data statement RETURNS create procedure RIGHT function , qualified table ROW fetch clause , for each row trigger action , limit clause , text table ROWS fetch clause , limit clause SECOND function SELECT select clause SET add set option , option namespace , update statement SHORT data type SIMILAR match predicate SMALLINT data type SOME standard aggregate function , quantified comparison predicate SQLEXCEPTION sql exception SQLSTATE sql exception SQLWARNING raise statement STRING dynamic data statement , data type , xml serialize TABLE alter options , create procedure , create foreign temp table , create table , create temporary table , drop table , query primary , table subquery TEMPORARY create foreign temp table , create temporary table THEN case expression , searched case expression TIME data type TIMESTAMP data type TINYINT data type TO match predicate TRAILING function TRANSLATE function TRIGGER alter , create trigger TRUE non numeric literal UNION cross join , query expression body UNIQUE other constraints , table element UNKNOWN non numeric literal UPDATE alter , create trigger , dynamic data statement , update statement USER function USING dynamic data statement VALUES insert statement VARBINARY data type , xml serialize VARCHAR data type , xml serialize VIRTUAL alter options , create procedure , create table , procedure body definition WHEN case expression , searched case expression WHERE filter clause , where clause WHILE while statement WITH assignment statement , query expression , data statement WITHOUT assignment statement , data statement XML data type XMLAGG ordered aggregate function XMLATTRIBUTES xml attributes XMLCOMMENT function XMLCONCAT function XMLELEMENT xml element XMLFOREST xml forest XMLNAMESPACES xml namespaces XMLPARSE xml parse XMLPI function XMLQUERY xml query XMLSERIALIZE xml serialize XMLTABLE xml table YEAR function

Commands: