Export (0) Print
Expand All

SQL Reserved Words

Office 2007

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

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.

Bb208875.vs_note(en-us,office.12).gif  Note
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

ABSOLUTEANY
ADDARE
ADMINDBAS
ALLASC
Alphanumeric — See TEXTASSERTION
ALTERAUTHORIZATION
ALTER TABLEAUTOINCREMENT — See COUNTER
AndAvg
AS 

B-C

BEGINCOLLATION
BetweenCOLUMN
BINARYCOMMIT
BITCOMP, COMPRESSION
BIT_LENGTHCONNECT
BOOLEAN — See BITCONNECTION
BOTHCONSTRAINT, CONSTRAINTS
BYCONTAINER
BYTECONTAINS
CASCADECONVERT
CATALOGCount
CHAR, CHARACTER — See TEXTCOUNTER
CHAR_LENGTHCREATE
CHARACTER_LENGTHCURRENCY
CHECKCURRENT_DATE
CLOSECURRENT_TIME
CLUSTEREDCURRENT_TIMESTAMP
COALESCECURRENT_USER
COLLATECURSOR

D

DATABASEDISALLOW
DATE — See DATETIMEDISCONNECT
DATETIMEDISTINCT
DAYDISTINCTROW
DEC, DECIMALDOMAIN
DECLAREDOUBLE
DELETEDROP
DESC 

E-H

EqvFOREIGN
EXCLUSIVECONNECTFROM
EXEC, EXECUTEFROM Clause
EXISTSGENERAL — See LONGBINARY
EXTRACTGRANT
FALSEGROUP
FETCHGUID
FIRSTHAVING
FLOAT, FLOAT8 — See DOUBLEHOUR
FLOAT4 — See SINGLE 

I

IDENTITYINPUT
IEEEDOUBLE — See DOUBLEINSENSITIVE
IEEESINGLE — See SINGLEINSERT
IGNOREINSERT INTO
IMAGEINT, INTEGER, INTEGER4 — See LONG
ImpINTEGER1 — See BYTE
InINTEGER2 — See SHORT
ININTERVAL
INDEXINTO
INDEXCREATEDBIs
INNERISOLATION

J-M

JOINLONGTEXT
KEYLOWER
LANGUAGEMATCH
LASTMax
LEFTMEMO — See LONGTEXT
Level*Min
LikeMINUTE
LOGICAL, LOGICAL1 — See BITMod
LONGMONEY — See CURRENCY
LONGBINARYMONTH
LONGCHAR 

N-P

NATIONALOuter*
NCHAROUTPUT
NONCLUSTEREDOWNERACCESS
NotPAD
NTEXTPARAMETERS
NULLPARTIAL
NUMBER — See DOUBLEPASSWORD
NUMERIC — See DECIMALPERCENT
NVARCHARPIVOT
OCTET_LENGTHPOSITION
OLEOBJECT — See LONGBINARYPRECISION
ONPREPARE
OPENPRIMARY
OPTIONPRIVILEGES
OrPROC, PROCEDURE
ORDERPUBLIC

Q-S

REAL — See SINGLESMALLDATETIME
REFERENCESSMALLINT — See SHORT
RESTRICTSMALLMONEY
REVOKESOME
RIGHTSPACE
ROLLBACKSQL
SCHEMASQLCODE, SQLERROR, SQLSTATE
SECONDStDev
SELECTStDevP
SELECTSCHEMASTRING — See TEXT
SELECTSECURITYSUBSTRING
SETSum
SHORTSYSNAME
SINGLESYSTEM_USER
SIZE 

T-Z

TABLEUPDATEOWNER
TableID*UPDATESECURITY
TEMPORARYUPPER
TEXTUSAGE
TIME — See DATETIMEUSER
TIMESTAMPUSING
TIMEZONE_HOURVALUE
TIMEZONE_MINUTEVALUES
TINYINTVar
TOVARBINARY — See BINARY
TOPVARCHAR — See TEXT
TRAILINGVarP
TRANSACTIONVARYING
TRANSFORMVIEW
TRANSLATEWHEN
TRANSLATIONWHENEVER
TRIMWHERE
TRUEWITH
UNIONWORK
UNIQUEXor
UNIQUEIDENTIFIERYEAR
UNKNOWNYESNO — See BIT
UPDATEZONE
UPDATEIDENTITY 


Community Additions

ADD
Show:
© 2014 Microsoft