Show Table of Contents
A.3. Non-Reserved Keywords
|
Keyword
|
Usage
|
|---|---|
|
ACCESSPATTERN
|
other constraints , non-reserved identifier
|
|
ARRAYTABLE
|
array table , non-reserved identifier
|
|
AUTO_INCREMENT
|
table element , non-reserved identifier
|
|
AVG
|
standard aggregate function , non-reserved identifier
|
|
CHAIN
|
sql exception , non-reserved identifier
|
|
COLUMNS
|
array table , non-reserved identifier , object table , text table , xml table
|
|
CONTENT
|
non-reserved identifier , xml parse , xml serialize
|
|
COUNT
|
standard aggregate function , non-reserved identifier
|
|
DELIMITER
|
non-reserved identifier , text aggregate function , text table
|
|
DENSE_RANK
|
analytic aggregate function , non-reserved identifier
|
|
DISABLED
|
alter , non-reserved identifier
|
|
DOCUMENT
|
non-reserved identifier , xml parse , xml serialize
|
|
EMPTY
|
non-reserved identifier , xml query
|
|
ENABLED
|
alter , non-reserved identifier
|
|
ENCODING
|
non-reserved identifier , text aggregate function , xml serialize
|
|
EVERY
|
standard aggregate function , non-reserved identifier
|
|
EXCEPTION
|
compound statement , declare statement , non-reserved identifier
|
|
EXCLUDING
|
non-reserved identifier , xml serialize
|
|
EXTRACT
|
function , non-reserved identifier
|
|
FIRST
|
fetch clause , non-reserved identifier , sort specification
|
|
HEADER
|
non-reserved identifier , text aggregate function , text table
|
|
INCLUDING
|
non-reserved identifier , xml serialize
|
|
INDEX
|
other constraints , table element , non-reserved identifier
|
|
INSTEAD
|
alter , create trigger , non-reserved identifier
|
|
JSONARRAY_AGG
|
non-reserved identifier , ordered aggregate function
|
|
JSONOBJECT
|
json object , non-reserved identifier
|
|
KEY
|
table element , create temporary table , foreign key , non-reserved identifier , primary key
|
|
LAST
|
non-reserved identifier , sort specification
|
|
MAX
|
standard aggregate function , non-reserved identifier
|
|
MIN
|
standard aggregate function , non-reserved identifier
|
|
NAME
|
function , non-reserved identifier , xml element
|
|
NAMESPACE
|
option namespace , non-reserved identifier
|
|
NEXT
|
fetch clause , non-reserved identifier
|
|
NULLS
|
non-reserved identifier , sort specification
|
|
OBJECTTABLE
|
non-reserved identifier , object table
|
|
ORDINALITY
|
non-reserved identifier , xml table column
|
|
PASSING
|
non-reserved identifier , object table , xml query , xml table
|
|
PATH
|
non-reserved identifier , xml table column
|
|
QUERYSTRING
|
non-reserved identifier , querystring function
|
|
QUOTE
|
non-reserved identifier , text aggregate function , text table
|
|
RAISE
|
non-reserved identifier , raise statement
|
|
RANK
|
analytic aggregate function , non-reserved identifier
|
|
RESULT
|
non-reserved identifier , procedure parameter
|
|
ROW_NUMBER
|
analytic aggregate function , non-reserved identifier
|
|
SELECTOR
|
non-reserved identifier , text table column , text table
|
|
SERIAL
|
non-reserved identifier , temporary table element
|
|
SKIP
|
non-reserved identifier , text table
|
|
SQL_TSI_DAY
|
time interval , non-reserved identifier
|
|
SQL_TSI_FRAC_SECOND
|
time interval , non-reserved identifier
|
|
SQL_TSI_HOUR
|
time interval , non-reserved identifier
|
|
SQL_TSI_MINUTE
|
time interval , non-reserved identifier
|
|
SQL_TSI_MONTH
|
time interval , non-reserved identifier
|
|
SQL_TSI_QUARTER
|
time interval , non-reserved identifier
|
|
SQL_TSI_SECOND
|
time interval , non-reserved identifier
|
|
SQL_TSI_WEEK
|
time interval , non-reserved identifier
|
|
SQL_TSI_YEAR
|
time interval , non-reserved identifier
|
|
STDDEV_POP
|
standard aggregate function , non-reserved identifier
|
|
STDDEV_SAMP
|
standard aggregate function , non-reserved identifier
|
|
SUBSTRING
|
function , non-reserved identifier
|
|
SUM
|
standard aggregate function , non-reserved identifier
|
|
TEXTAGG
|
non-reserved identifier , text aggregate function
|
|
TEXTTABLE
|
non-reserved identifier , text table
|
|
TIMESTAMPADD
|
function , non-reserved identifier
|
|
TIMESTAMPDIFF
|
function , non-reserved identifier
|
|
TO_BYTES
|
function , non-reserved identifier
|
|
TO_CHARS
|
function , non-reserved identifier
|
|
TRIM
|
function , non-reserved identifier , text table column
|
|
VARIADIC
|
non-reserved identifier , procedure parameter
|
|
VAR_POP
|
standard aggregate function , non-reserved identifier
|
|
VAR_SAMP
|
standard aggregate function , non-reserved identifier
|
|
VERSION
|
non-reserved identifier , xml serialize
|
|
VIEW
|
alter , alter options , create table , non-reserved identifier
|
|
WELLFORMED
|
non-reserved identifier , xml parse
|
|
WIDTH
|
non-reserved identifier , text table column
|
|
XMLDECLARATION
|
non-reserved identifier , xml serialize
|
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.