Was this helpful?
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: 01/30/2023