|
|
|
|
|
The following is a list of words that are part of the SQL grammar that will need quoting to be used as column names:
Note: Custom table names containing dashes (-) will also need quoting in SQL Queries.
abs
absolute
ada
advancedjoinopt
all
allocate
and
any
as
asc
at
atomic
avg
begin
between
bit
bit_length
both
by
byte
call
case
cast
char
char_length
character
character_length
close
coalesce
collate
comp
comment
contains
continue
convert
corresponding
count
create
cross
current
current_date
current_time
current_timestamp
current_user
cursor
data
date
dateperiod
day
deallocate
dec
decimal
declare
default
delete
desc
descriptor
distinct
do
double
drop
else
elseif
end
escape
except
execute
exists
exit
external
extract
false
fetch
filter
first
float
for
found
from
full
function
general
global
group
handler
having
hint
hour
if
ifnull
immediate
in
inactive
indicator
inner
inout
insensitive
insert
int
integer
intersect
into
is
join
largeint
last
leading
leave
left
length
like
lineno
local
loop
lower
match
max
min
minute
modifies
module
month
NAME
national
natural
nchar
next
no
nojoinswap
not
null
nullif
numeric
occurs
octet_length
of
on
only
open
or
order
out
outer
overlaps
parameter
partial
password
pos
position
precision
prepare
prior
procedure
read
reads
real
relative
repeat
replace
return
returns
right
role
round
scroll
second
select
selectivity
session_user
set
smallint
some
sql
sqlexeception
sqlstate
sqlwarning
style
substring
sum
system_user
table
then
time
timestamp
timezone_hour
timezone_minute
to
trailing
translate
trim
true
type
undo
union
unique
update
upper
user
using
value
values
varchar
varying
when
where
while
with
word
year
zone