Switch to: V10V9V8V7V6V5
Table of Contents

KEYWORDS

List of keywords (reserved words) of Valentina SQL.

Note, that you can always easy to get list of keywords for your current Valentina engine using VSQL command “SHOW VKEYWORDS”.

Note, that you should avoid to use keywords of VSQL as names of your db objects. In case this is required you should use double quotes around such names in your SQL commands. Also tend to use TIP about naming db objects with prefixes.

SLECT * FROM "global";

A

absolute
action
add
admin
after
all
alter
ancestors          [v4.1]
and
any
as
asc
at
auto               [v4.0]
auto_increment
autoincrement
avg

B

backup
backward
base64           [v5.0]
before
begin
between
bigint
binary
bit
bit_and
bit_length
bit_or
bit_xor
blob
boolean
both
brothers         [v4.1]
by
byte

C

call
cascade
case
cast
cdata               [v4.0]
change
char
character
check
checks              [v5.0]
clone
close
coalesce
collate
column
columns
comment
commit
committed
compact
completion
compressed
connection
connections        [v4.0]  
constraint
convert
copy
corr
count
covar
create
current_date
current_role
current_time
current_timestamp
current_user
cursor
cyrcle              [v5.0]

D

data
database
databases
date
datetime
ddl                 [v5.0]
dec
decimal
declare
default
defragment
delete
desc          
descendants         [v4.1]
diagnose
disable
disabled
distinct
do
double
drop

E

each
element           [v4.0]
elements          [v4.0]
else
elseif
enable
enabled
encode            [v5.0]
end
ends
escape
event
events
every
except
execute
exception
exists

F

false
fetch
field
fields
first
fixedbinary
float
for
foreign
forward
from
full

G

get
global
grant
granted
group

H

having
html             [v4.0]
high

I

identity
if
ignore           [v4.0]
in
increment        [v5.0]
index
indexed
indexes          [v5.0]
infile           [v4.0]
inner
inout
insert
instead
int
integer
intersect
interval
into
is
is_leaf          [v5.0]
isolation
iterate

J

join
jpg               [v4.0]
json              [v5.5]

K

key

L

last
leading
leave
left
level
like
limit
lines             [v4.0]
link
links
llong
load              [v4.0]
local
log               [v5.0]
logoff            [v5.0]
logon             [v5.0]
long
longtext
loop
low
lower

M

many
match
max
maxvalue        [v5.0]
medium
mediumint
mediumtext
method
min
minvalue        [v5.0]
modify

N

natural
new
next
no
none
normal
not
null
nullif
nulls
numeric

O

objectptr
of
offset
old
on
one
only
open
option
or
order
others
out
outer
overlaps
owner

P

pages               [v4.0]
partial
pdf                 [v4.0]
picture
pivot
position
precision
preserve
primary
print
prior
privileges
procedure
procedures
project             [v4.0]
projects            [v4.0] 
properties
property
public

R

ram
raise
raiseerror
raw                [v4.0]
rdblink
read
real
record
records
references
referencing
regex
regexp
reindex
relative
rename
repair
repeat
repeatable
replace
report             [v4.0]
restrict
revoke
right
role
rollback
rollup
row
rows

S

schedule
select
serial32             [v5.0]
serial64             [v5.0]
serializable
server
sequence             [v5.0]
sequences            [v5.0]
session_user
set
short
show
shutdown             [v5.0]
smallint
some
start                [v5.0]
starts
startup              [v5.0]
statement
statistic
status
std
stddev
stddev_pop
string
structure
substring
sum
system_user

T

table
tables
temporary
terminated         [v4.0]
text
then
time
timestamp
tinyint
tinytext
to
trailing
transaction
trigger
triggers
trim
true
type              [v5.0]
types             [v5.0]

U

uchar
ullong
ulong
umedium
uncommitted
under
union
unique
unknown
unlink
unsigned
until
update
upper
usage
use
user
users
ushort
using

V

value
values
varbinary
varchar
varying
verbose
veryhigh
view

W

when
where
while
with
words
work
write

X

x
xml              [v4.0]
xmlagg
xmlattributes
xmlelement
xmlforest

Z

zerofill
zone