Switch to: V9V8V7V6V5
Table of Contents

KEYWORDS

List of keywords (reserved words) of Valentina SQL.

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

Note, that you should avoid using 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
are                [v8.0]
array              [v8.0]
as
asc
ascendants
assertion          [v8.0]
asymmetric         [v8.0] 
at
authorization      [v8.0]
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
channel
channels
char
character
check
checks              [v5.0]
clone
close
coalesce
collate
column
columns
comment
commit
committed
compact
completion
compressed
connection
connections        [v4.0]  
constraint
constraints
constructor        [v8.0]
convert
copy
corr
count
covar
create
cross
cube
current
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
domain              [v8.0]
double
drop
duplicate           [v8.0]
dynamic             [v8.0]

E

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

F

false
fetch
field
fields
filter
final
first
fixedbinary
flag
float
for
foreign
forward
free
from
full
function
fusion

G

get
global
grant
granted
group

H

hash
having
high
hold
hour
html             [v4.0]

I

identified
identity
if
ignore           [v4.0]
ilike
immediate
in
increment        [v5.0]
index
indexed
indexes          [v5.0]
indicator
infile           [v4.0]
initially
inner
inout
insert
instance
instantiable
instead
int
integer
intersect
intersection
interval
into
is
is_leaf          [v5.0]
isolation
iterate

J

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

K

key
keyvalue              [v7.0]
keyvalues             [v7.0]

L

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

M

many
match
matched         [v6.0]
max
maxvalue        [v5.0]
medium
mediumint
mediumtext
member          [v8.0]
merge           [v7.0]
method
min
minvalue        [v5.0]
modifies
modify
module
money
multiset        [v8.0]

N

natural
new
next
no
none
normal
normalize
not
null
nullif
nulls
numeric

O

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

P

pages               [v4.0]
parameter
parentdirection
partial
partition
password
pdf                 [v4.0]
picture
pivot
position
precision
prepare
preserve
primary
print
prior
privileges
procedure
procedures
project             [v4.0]
projects            [v4.0] 
properties
property

R

raise
raiseerror
ram
raw                [v4.0]
rdblink
read
real
record
records
ref
references
referencing
regex
regexp
register
reindex
relative
release
rename
repair
repeat
repeatable
replace
report             [v4.0]
restrict
result
return
returns
revoke
right
rlike
role
rollback
rollup
root
roots
row
row_number
rows

S

savepoint
schedule
schema
scope
scroll
search
select
separator
sequence             [v5.0]
sequences            [v5.0]
serial32             [v5.0]
serial64             [v5.0]
serializable
server
session_user
set
short
show
shutdown             [v5.0]
similar
simple
smallint
some 
source               [v6.0]
specific
specifictype
start                [v5.0]
starts
startup              [v5.0]
statement
static
statistic
status
std
stddev
stddev_pop
string
structure
style
styles
subscribe
substring
substring_regex
sum
symmetric
system
system_user

T

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

U

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

V

value
values
varbinary
varchar
variables
variant           [v7.0]
varying
verbose
veryhigh
vidents
view
vkeywords

W

when
whenever
where
while
window
with
within
without
words
work
write

X

x
xml              [v4.0]
xmlagg
xmlattributes
xmlelement
xmlforest

Z

zerofill
zone