SQL reserved words

Applies to: Access 2013, Office 2013

The following list includes all words reserved by the Microsoft Access database engine for use in SQL statements.

• The words in the list that are not in all uppercase letters are also reserved by other applications. Consequently, the individual Help topics for these words provide general descriptions that do not focus on SQL usage.

• Words followed by an asterisk (*) are reserved, but currently have no meaning in the context of a Microsoft Access SQL statement (for example, Level and TableID).

• Words that are not underlined do not have linked explanations.

A

ABSOLUTE	ANY
ADD	ARE
ADMINDB	AS
ALL	ASC
Alphanumeric — See TEXT	ASSERTION
ALTER	AUTHORIZATION
ALTER TABLE	AUTOINCREMENT — See COUNTER
And	Avg
AS

B-C

BEGIN	COLLATION
Between	COLUMN
BINARY	COMMIT
BIT	COMP, COMPRESSION
BIT_LENGTH	CONNECT
BOOLEAN — See BIT	CONNECTION
BOTH	CONSTRAINT, CONSTRAINTS
BY	CONTAINER
BYTE	CONTAINS
CASCADE	CONVERT
CATALOG	Count
CHAR, CHARACTER — See TEXT	COUNTER
CHAR_LENGTH	CREATE
CHARACTER_LENGTH	CURRENCY
CHECK	CURRENT_DATE
CLOSE	CURRENT_TIME
CLUSTERED	CURRENT_TIMESTAMP
COALESCE	CURRENT_USER
COLLATE	CURSOR

D

DATABASE	DISALLOW
DATE — See DATETIME	DISCONNECT
DATETIME	DISTINCT
DAY	DISTINCTROW
DEC, DECIMAL	DOMAIN
DECLARE	DOUBLE
DELETE	DROP
DESC

E-H

Eqv	FOREIGN
EXCLUSIVECONNECT	FROM
EXEC, EXECUTE	FROM Clause
EXISTS	GENERAL — See LONGBINARY
EXTRACT	GRANT
FALSE	GROUP
FETCH	GUID
FIRST	HAVING
FLOAT, FLOAT8 — See DOUBLE	HOUR
FLOAT4 — See SINGLE

I

IDENTITY	INPUT
IEEEDOUBLE — See DOUBLE	INSENSITIVE
IEEESINGLE — See SINGLE	INSERT
IGNORE	INSERT INTO
IMAGE	INT, INTEGER, INTEGER4 — See LONG
Imp	INTEGER1 — See BYTE
In	INTEGER2 — See SHORT
IN	INTERVAL
INDEX	INTO
INDEXCREATEDB	Is
INNER	ISOLATION

J-M

JOIN	LONGTEXT
KEY	LOWER
LANGUAGE	MATCH
LAST	Max
LEFT	MEMO — See LONGTEXT
Level*	Min
Like	MINUTE
LOGICAL, LOGICAL1 — See BIT	Mod
LONG	MONEY — See CURRENCY
LONGBINARY	MONTH
LONGCHAR

N-P

NATIONAL	Outer*
NCHAR	OUTPUT
NONCLUSTERED	OWNERACCESS
Not	PAD
NTEXT	PARAMETERS
NULL	PARTIAL
NUMBER — See DOUBLE	PASSWORD
NUMERIC — See DECIMAL	PERCENT
NVARCHAR	PIVOT
OCTET_LENGTH	POSITION
OLEOBJECT — See LONGBINARY	PRECISION
ON	PREPARE
OPEN	PRIMARY
OPTION	PRIVILEGES
Or	PROC, PROCEDURE
ORDER	PUBLIC

Q-S

REAL — See SINGLE	SMALLDATETIME
REFERENCES	SMALLINT — See SHORT
RESTRICT	SMALLMONEY
REVOKE	SOME
RIGHT	SPACE
ROLLBACK	SQL
SCHEMA	SQLCODE, SQLERROR, SQLSTATE
SECOND	StDev
SELECT	StDevP
SELECTSCHEMA	STRING — See TEXT
SELECTSECURITY	SUBSTRING
SET	Sum
SHORT	SYSNAME
SINGLE	SYSTEM_USER
SIZE

T-Z

TABLE	UPDATEOWNER
TableID*	UPDATESECURITY
TEMPORARY	UPPER
TEXT	USAGE
TIME — See DATETIME	USER
TIMESTAMP	USING
TIMEZONE_HOUR	VALUE
TIMEZONE_MINUTE	VALUES
TINYINT	Var
TO	VARBINARY — See BINARY
TOP	VARCHAR — See TEXT
TRAILING	VarP
TRANSACTION	VARYING
TRANSFORM	VIEW
TRANSLATE	WHEN
TRANSLATION	WHENEVER
TRIM	WHERE
TRUE	WITH
UNION	WORK
UNIQUE	Xor
UNIQUEIDENTIFIER	YEAR
UNKNOWN	YESNO — See BIT
UPDATE	ZONE
UPDATEIDENTITY