ANSI/ISO SQL Keywords
The following keywords are ANSI/ISO standard keywords that are not reserved in Ingres SQL or Ingres Embedded SQL. You may want to treat these as reserved words to ensure compatibility with other implementations of SQL.
absolute
action
allocate
alter
are
asc
asensitive
assertion
atomic
atomic
bit
bit_length
both
called
cardinality
cascaded
case
cast
catalog
char
char_length
character
character_length
coalesce
collate
collation
collect
condition
connection
constraints
convert
corr
corresponding
cross
cube
current_date
current_default_transform_group
current_path
current_role
current_time
current_timestamp
date
day
deallocate
dec
decimal
deferrable
deferred
deref
desc
deterministic
diagnostics
domain
double
dynamic
each
element
else
every
except
exception
exec
external
extract
false
filter
first
float
found
free
function
fusion
get
go
grouping
hold
hour
identity
initially
inout
input
insensitive
int
integer
intersect
intersection
intersects
interval
isolation
language
large
last
lateral
leading
level
ln
localtime
localtimestamp
lower
match
member
merge
method
minute
mod
modifies
module
month
multiset
names
national
nchar
new
no
none
normalize
nullif
numeric
octet_length
old
only
option
outer
output
over
overlaps
overlay
pad
parameter
partial
partition
position
precision
prior
privileges
rank
read
reads
real
recursive
ref
relative
release
returns
rollup
row_number
scope
search
second
sensitive
similar
size
smallint
space
specific
specifictype
sql
sqlcode
sqlerror
sqlexception
sqlstate
sqlwarning
static
submultiset
substring
symmetric
tablesample
then
time
timestamp
timezone_hour
timezone_minute
trailing
transaction
translate
translation
treat
trigger
trim
true
uescape
unknown
unnest
upper
usage
value
varchar
varying
width_bucket
window
within
without
work
write
year
zone
Last modified date: 04/03/2024