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