Appendix D: Microsoft Jet 4.0 ANSI Reserved Words

Microsoft Jet 4.0 provides enhanced support for ANSI 92 keywords. For example, with Microsoft Jet 4.0 you can use the ANSI CREATE PROCEDURE syntax to create a new query. As a result of this support there are a number of new reserved words. If you have table or column names that conflict with one of the reserved words, you will now get a syntax error when referencing it in a query.

ABSOLUTE	DECIMAL	IS	ROWS
ACTION	DECLARE	ISOLATION	SCHEMA
ADD	DEFAULT	JOIN	SCROLL
ALL	DEFERRABLE	KEY	SECOND
ALLOCATE	DEFERRED	LANGUAGE	SECTION
ALTER	DELETE	LAST	SELECT
AND	DESCRIBE	LEADING	SESSION
ANY	DESC	LEFT	SESSION_USER
ARE	DESCRIPTOR	LEVEL	SET
AS	DIAGNOSTICS	LIKE	SIZE
ASC	DISCONNECT	LOCAL	SMALLINT
ASSERTION	DISTINCT	LOWER	SOME
AT	DOMAIN	MATCH	SQL
AUTHORIZATION	DOUBLE	MAX	SQLCODE
AVG	DROP	MIN	SQLERROR
BEGIN	ELSE	MINUTE	SQLSTATE
BETWEEN	END	MODULE	SUBSTRING
BIT	END-EXEC	MONTH	SUM
BIT_LENGTH	ESCAPE	NAMES	SYSTEM_USER
BOTH	EXCEPT	NATIONAL	TABLE
BY	EXCEPTION	NATURAL	TEMPORARY
CASCADE	EXEC	NCHAR	THEN
CASCADED	EXECUTE	NEXT	TIME
CASE	EXISTS	NO	TIMESTAMP
CAST	EXTERNAL	NOT	TIMEZONE_HOUR
CATALOG	EXTRACT	NULL	TIMEZONE_MINUTE
CHAR	FALSE	NULLIF	TO
CHARACTER	FETCH	NUMERIC	TRAILING
CHAR_LENGTH	FIRST	OCTET_LENGTH	TRANSACTION
CHARACTER_LENGTH	FLOAT	OF	TRANSLATE
CHECK	FOR	ON	TRANSLATION
CLOSE	FOREIGN	ONLY	TRIM
COALESCE	FOUND	OPEN	TRUE
COLLATE	FROM	OPTION	UNION
COLLATION	FULL	OR	UNIQUE
COLUMN	GET	ORDER	UNKNOWN
COMMIT	GLOBAL	OUTER	UPDATE
CONNECT	GO	OUTPUT	UPPER
CONNECTION	GOTO	OVERLAPS	USAGE
CONSTRAINT	GRANT	PARTIAL	USER
CONSTRAINTS	GROUP	POSITION	USING
CONTINUE	HAVING	PRECISION	VALUE
CONVERT	HOUR	PREPARE	VALUES
CORRESPONDING	IDENTITY	PRESERVE	VARCHAR
COUNT	IMMEDIATE	PRIMARY	VARYING
CREATE	IN	PRIOR	VIEW
CROSS	INDICATOR	PRIVILEGES	WHEN
CURRENT	INITIALLY	PROCEDURE	WHENEVER
CURRENT_DATE	INNER	PUBLIC	WHERE
CURRENT_TIME	INPUT	READ	WITH
CURRENT_TIMESTAMP	INSENSITIVE	REAL	WORK
CURRENT_USER	INSERT	REFERENCES	WRITE
CURSOR	INT	RELATIVE	YEAR
DATE	INTEGER	RESTRICT	ZONE
DAY	INTERSECT	REVOKE
DEALLOCATE	INTERVAL	RIGHT
DEC	INTO	ROLLBACK