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
|