Reference Manual
   CHAPTER 6. SQL Language Elements     

Alphabetical list of keywords

To use a keyword (also called a reserved word) as an identifier, you must enclose it in double quotes when referencing it in a SQL statement. Many, but not all, of the words that appear in SQL statements are keywords. 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, each of the following words may appear in upper case, lower case, 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 database library function sql_needs_quotes 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.

List of reserved words
add	all	alter	and
any	as	asc	backup
begin	between	bigint	binary
bit	bottom	break	by
call	cascade	case	cast
char	char_convert	character	check
checkpoint	close	comment	commit
connect	constraint	continue	convert
create	cross	current	cursor
date	dbspace	deallocate	dec
decimal	declare	default	delete
desc	disable	distinct	do
double	drop	dynamic	else
elseif	enable	encrypted	end
endif	escape	exception	exec
execute	existing	exists	externlogin
fetch	first	float	for
foreign	forward	from	full
goto	grant	group	having
holdlock	identified	if	in
index	inner	inout	insensitive
insert	install	instead	int
integer	integrated	into	iq
is	isolation	join	key
left	like	lock	login
long	match	membership	message
mode	modify	natural	new
no	noholdlock	not	notify
null	numeric	of	off
on	open	option	options
or	order	others	out
outer	passthrough	precision	prepare
primary	print	privileges	proc
procedure	publication	raiserror	readtext
real	reference	references	release
remote	remove	rename	resource
restore	restrict	return	revoke
right	rollback	save	savepoint
schedule	scroll	select	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	union	unique	unknown
unsigned	update	user	using
validate	values	varbinary	varchar
variable	varying	view	when
where	while	with	work
writetext