Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Language Elements » Keywords

Keywords Next Page

Reserved words


Some keywords in SQL are also reserved words. To use a reserved word in a SQL statement as an identifier, you must enclose it in double quotes. Many, but not all, of the keywords that appear in SQL statements are reserved words. For example, you must use the following syntax to retrieve the contents of a table named SELECT.

SELECT *
FROM "SELECT"

Because SQL is not case sensitive with respect to keywords, each of the following words may appear in uppercase, lowercase, or any combination of the two. All strings that differ only in capitalization from one of the following words are reserved words.

If you are using embedded SQL, you can use the sql_needs_quotes database library function to determine whether a string requires quotation marks. A string requires quotes if it is a reserved word or if it contains a character not ordinarily allowed in an identifier.

For more information, see sql_needs_quotes function.

The reserved SQL keywords in SQL Anywhere are as follows:

add all alter and
any as asc attach
backup begin between bigint
binary bit bottom break
by call capability cascade
case cast char char_convert
character check checkpoint close
comment commit compressed conflict
connect constraint contains continue
convert create cross cube
current current_timestamp current_user cursor
date dbspace deallocate dec
decimal declare default delete
deleting desc detach distinct
do double drop dynamic
else elseif encrypted end
endif escape except exception
exec execute existing exists
externlogin fetch first float
for force foreign forward
from full goto grant
group having holdlock identified
if in index index_lparen
inner inout insensitive insert
inserting install instead int
integer integrated intersect into
iq is isolation join
kerberos key lateral left
like lock login long
match membership message mode
modify natural nchar new
no noholdlock not notify
null numeric nvarchar of
off on open option
options or order others
out outer over passthrough
precision prepare primary print
privileges proc procedure publication
raiserror readtext real reference
references refresh release remote
remove rename reorganize resource
restore restrict return revoke
right rollback rollup save
savepoint scroll select sensitive
session set setuser share
smallint some sqlcode sqlstate
start stop subtrans subtransaction
synchronize syntax_error table temporary
then time timestamp tinyint
to top tran trigger
truncate tsequal unbounded union
unique uniqueidentifier unknown unsigned
update updating user using
validate values varbinary varbit
varchar variable varying view
wait waitfor when where
while window with with_cube
with_lparen with_rollup within work
writetext xml