A.3. Non-Reserved Keywords


Expand
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
Red Hat logoGithubredditYoutubeTwitter

Learn

Try, buy, & sell

Communities

About Red Hat Documentation

We help Red Hat users innovate and achieve their goals with our products and services with content they can trust. Explore our recent updates.

Making open source more inclusive

Red Hat is committed to replacing problematic language in our code, documentation, and web properties. For more details, see the Red Hat Blog.

About Red Hat

We deliver hardened solutions that make it easier for enterprises to work across platforms and environments, from the core datacenter to the network edge.

Theme

© 2026 Red Hat
Back to top