Appendix A    ODBC Reserved Words

This appendix covers the ODBC reserved words, listed in the following table.

ALL	AND	AS	ASC
BY	CREATE	DELETE	DESC
DISTINCT	DROP	FROM	INNER
INSERT	JOIN	LEFT	LIKE
NOT	ON	OR	ORDER
OUTER	RIGHT	SELECT	UNION
UPDATE	WHERE

When you create a relational view of your JADE database by using the Relational Views Wizard, some words should not be used as Table or Column names if the configuration setting for ODBC reserved words that the JADE ODBC driver will use is Upper and Lower. (For details about minimizing ODBC reserved word conflicts by converting the ODBC reserved words to an initial capital letter, see "Configuring a JADE ODBC Driver", in Chapter 2.)