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 keyvalue [v7.0] keyvalues [v7.0]
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 matched [v6.0] 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 source [v6.0] start [v5.0] starts startup [v5.0] statement statistic status std stddev stddev_pop string structure substring sum system_user
T
table tables target [v6.0] 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 variant [v7.0] varying verbose veryhigh view
W
when where while with words work write
X
x xml [v4.0] xmlagg xmlattributes xmlelement xmlforest
Z
zerofill zone