Reserved Words

Reserved Words (Abbreviated List**)

A

ABSOLUTE*

ACTION*

ADD*

ADMINDB*

ALL*

ALLOCATE*

Alphanumeric*

ALTER*

AND*

ANY*

Application

ARE*

AS*

ASC*

ASSERTION*

Assitant

AT*

AUTHORIZATION*

AUTOINCREMENT*

Avg*

AUTHORIZATION

B

BACKUP

BAND*

BEGIN*

BETWEEN*

BINARY*

BIT*

BIT_LENGTH*

BNOT*

BOR*

BOTH*

BREAK

BROWSE

BULK

BXOR*

BY*

BYTE*

C

CASCADE*

CASCADED*

CASE*

CAST*

CATALOG*

CHAR*

CHAR_LENGTH*

CHARACTER*

CHARACTER_LENGTH*

CHECK*

CHECKPOINT

CLOSE*

CLUSTERED

COALESCE*

COLLATE*

COLLATION*

COLUMN*

COMMIT*

COMP*

CompactDatabase

COMPRESSION*

COMPUTE

CONNECT*

CONNECTION*

CONSTRAINT*

CONSTRAINTS*

CONTAINS

Container*

CONTAINSTABLE

CONTINUE*

CONVERT*

CORRESPONDING*

Count*

COUNTER*

CREATE*

CREATEDB*

CreateDatabase

CreateField

CreateGroup

CreateIndex

CreateObject

CreateProperty

CreateRelation

CreateTableDef

CreateUser

CreateWorkspace

CROSS*

CURRENCY*

CURRENT*

CURRENT_DATE*

CURRENT_TIME*

CURRENT_TIMESTAMP*

CURRENT_USER*

CurrentUser

CURSOR*

D

DATABASE*

DATE*

DATETIME*

DAY*

DBCC

DEALLOCATE*

DEC*

DECIMAL*

DECLARE*

DEFAULT*

DEFERRABLE*

DEFERRED*

DELETE*

DENY

DESC*

DESCRIBE*

Description

DESCRIPTOR*

DIAGNOSTICS*

DISALLOW*

DISCONNECT*

DISK

DISTINCT*

DISTINCTROW

DISTRIBUTED

Document

DOMAIN*

DOUBLE*

DROP*

DUMP

E

Echo

ELSE*

END*

END-EXEC*

Eqv

ERRLVL

Error

ESCAPE*

EXCEPT*

EXCEPTION*

EXEC*

EXECUTE*

EXCLUSIVECONNECT*

EXISTS*

EXIT

EXTERNAL*

EXTRACT*

F

FALSE*

FETCH*

Field, Fields

FILE

FillCache

FILLFACTOR

FIRST*

FLOAT*

FLOAT4*

FLOAT8*

FOR*

FOREIGN*

Form, Forms

FOUND*

FREETEXT

FREETEXTTABLE

FROM*

FULL*

FUNCTION

G

GENERAL*

GET*

GetObject

GetOption

GLOBAL*

GO*

GOTO*

GotoPage

GRANT*

GROUP*

GROUPBY

GUID*

H

HAVING*

HOLDLOCK

HOUR*

I

IDENTITY*

IDENTITY_INSERT

IDENTITYCOL

Idle

IEEEDOUBLE*

IEEESINGLE*

IF

IGNORE*

IMAGE*

IMMEDIATE*

Imp

IN

Index

Indexes

INDICATOR*

INHERITABLE*

ININDEX*

INITIALLY*

INNER*

INPUT*

INSENSITIVE*

INSERT*

InsertText

INT*

INTEGER*

INTEGER1*

INTEGER2*

INTEGER4*

INTERSECT*

INTERVAL*

INTO*

IS*

ISOLATION*

J

JOIN*

K

KEY*

KILL

L

LANGUAGE*

LAST*

LastModified

LEADING*

LEFT*

Level*

LIKE*

LINENO

LOAD

LOCAL*

LOG

LOGICAL*

LOGICAL1*

LONG*

LONGBINARY*

LONGCHAR*

LONGTEXT*

LOWER*

M

Macro

Match*

Max*

Min*

MINUTE*

Mod

MODULE*

MONTH*

MEMO*

MERGE

Module*

MONEY*

Move

N

NAME

NAMES*

NATIONAL*

NATURAL*

NCHAR*

NewPassword

NEXT*

NO*

NOCHECK

NONCLUSTERED

NOT*

Note*

NULL*

NULLIF*

NUMBER*

NUMERIC*

O

Object*

OCTET_LENGTH*

OF

OFF

OFFSET

OFFSETS

OFOLEOBJECT*

OLEOBJECT

ON

ONONLY*

OPEN*

OpenRecordset

OPENDATASOURCE

OPENQUERY

OPENROWSET

OPENXML

OPTION*

OR

ORDER

Orientation

ORORDER*

OUTER*

OUTPUT*

OVER

OVERLAPS*

OWNERACCESS*

P

PAD*

Parameter

PARAMETERS*

Partial*

PASSWORD*

PERCENT*

PIVOT*

PLAN

POSITION*

PRECISION*

PREPARE*

PRESERVE*

PRIMARY*

PRINT

PRIOR*

PRIVILEGES*

PROC*

PROCEDURE*

Property

PUBLIC*

Q

Queries

Query

Quit

R

RAISERROR

READ*

READPAST

READTEXT

REAL*

Recalc

RECONFIGURE

Recordset

REFERENCES*

Refresh

RefreshLink

RegisterDatabase

Relation

RELATIVE*

Repaint

RepairDatabase

REPLICATION

Report

Reports

Requery

RESTORE

RESTRICT*

RETURN

REVERT

REVOKE*

RIGHT*

ROLLBACK*

ROWCOUNT

ROWGUIDCOL

ROWS*

RULE

S

SAVE

SCHEMA*

SCREEN

SCROLL*

SECOND*

SECTION*

SECURITYAUDIT

SELECT*

SELECTSCHEMA*

SELECTSECURITY*

SESSION*

SESSION_USER*

SET*

SetFocus

SetOption

SETUSER

SHORT*

SHUTDOWN

SINGLE*

SIZE*

SMALLINT*

SOME*

SPACE*

SQL*

SQLCODE*

SQLERROR*

SQLSTATE*

STATISTICS

StDev

StDevP

STRING*

SUBSTRING*

Sum*

SYSTEM_USER*

T

TABLE*

TableDef

TableDefs

TableID*

TABLESAMPLE

TEMPORARY*

TEXT*

TEXTSIZE

THEN*

TIME*

TIMESTAMP*

TIMEZONE_HOUR*

TO*

TOP*

TRAILING*

TRAN

TRANSACTION*

TRANSFORM*

TRANSLATE*

TRANSLATION*

TRIGGER

TRIM*

TRUE*

TRUNCATE

TSEQUAL

Type

U

UNION*

UNIQUE*

UNIQUEIDENTIFIER*

UNKNOWN*

UNPIVOT

UPDATE*

UPDATEIDENTITY*

UPDATEOWNER*

UPDATESECURITY*

UPDATETEXT

UPPER*

USE

USAGE*

USER*

USING*

V

VALUE*

VALUES*

Var, VarP

VARBINARY*

VARCHAR*

VARYING*

VIEW*

W

WAITFOR

WHEN*

WHENEVER*

WHERE*

WHILE

WITH*

WORK*

Workspace

WRITE*

WRITETEXT

X

Xor

Y

Year*

YES

YESNO*

Z

ZONE*

Legend

BLUE – SQL Server 2008 R2

MAROON – Microsoft Access

BLACK – Microsoft Access & SQL Server 2008 R2

* – Microsoft Access Database Engine

**For a complete list of Reserved Words see… Problem Names and Reserved Words in Microsoft Access by Allen Browne