What is a cume file

Reserved keywords (Access custom web app)

  • 4 minutes to read

Microsoft Access uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the language Access uses to parse and understand SQL statements Reserved keywords are part of the grammar of the language that is used by Access to parse and understand SQL statements.

Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. Alternatively, consider using Microsoft PowerApps for creating codeless business solutions for the web and for mobile devices. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Access reserved keywords

The following table lists Access reserved keywords.

ADDADD
FILLFACTOR FILLFACTOR
Quarter Quarter
EVERYONE
Float
RAISERRORRAISERROR
AGE
FOR FOR
Read READ
UNDAND
FOREIGNFOREIGN
READTEXTREADTEXT
ANYANY
FREETEXTFREETEXT
Configure RECONFIGURE
ASAS
FREETEXTTABLEFREETEXTTABLE
REFERENCESREFERENCES
ASCASC
FROMFROM
Replication REPLICATION
AUTHORIZATION AUTHORIZATION
COMPLETEFULL
RecoveryRESTORE
Backup BACKUP
Function FUNCTION
RESTRICTRESTRICT
BEGINNING
GOTOGOTO
ENTER RETURN
BETWEEN BETWEEN
GRANTGRANT
REVERTED
PAUSEBREAK
GroupGROUP
REVOKEREVOKE
Browse BROWSE
HAVINGHAVING
RIGHTRIGHT
Bulk BULK
HOLDLOCKHOLDLOCK
ROLLBACKROLLBACK
BYBY
Hour hour
ROWCOUNTROWCOUNT
CASCADECASCADE
IdentityIDENTITY
ROWGUIDCOLROWGUIDCOL
FallCASE
IDENTITY_INSERTIDENTITY_INSERT
RULE
CHECK CHECK
IDENTITYCOLIDENTITYCOL
SaveSAVE
Checkpoint CHECKPOINT
IfIF
SCHEME
CLOSECLOSE
ININ
Second second
CLUSTEREDCLUSTERED
INDEX INDEX
SECURITYAUDITSECURITYAUDIT
COALESCECOALESCE
INSIDE
SELECTSELECT
COLLATECOLLATE
INSERT
SEMANTICKEYPHRASETABLESEMANTICKEYPHRASETABLE
ColumnCOLUMN
Whole numberInteger
SEMANTICSIMILARITYDETAILSTABLESEMANTICSIMILARITYDETAILSTABLE
COMMITCOMMIT
INTERSECTINTERSECT
SEMANTICSIMILARITYTABLESEMANTICSIMILARITYTABLE
CALCULATE COMPUTE
INTOINTO
SESSION_USERSESSION_USER
ConstraintCONSTRAINT
ISTIS
SETSET
CONTAINSCONTAINS
ISO_WeekISO_Week
SETUSERSETUSER
CONTAINSTABLECONTAINSTABLE
JOIN JOIN
ShortTextShortText
CONTINUES TO CONTINUE
KeyKEY
SHUTDOWNSHUTDOWN
CONVERTCONVERT
KILL KILL
SOMESOME
CREATECREATE
LinksLEFT
StatisticsSTATISTICS
OVERALL DECROSS
WIELIKE
SYSTEM_USERSYSTEM_USER
CurrencyCurrency
LINENOLINENO
TABLETABLE
CURRENT CURRENT
LoadsLOAD
TABLESAMPLETABLESAMPLE
CURRENT_DATECURRENT_DATE
LongTextLongText
TextText
CURRENT_TIMECURRENT_TIME
MERGE MERGE
TEXT SIZE
CURRENT_TIMESTAMPCURRENT_TIMESTAMP
Millisecond
DANNTHEN
CURRENT_USERCURRENT_USER
Minute minute
TimeTime
CURSORCURSOR
MonthMonth
TOTO
DatabaseDATABASE
NATIONAL NATIONAL
TOP
Date
No no
TRANTRAN
DateWithTimeDateWithTime
NEXT CHECK
TRANSACTIONTRANSACTION
TagDay
NONCLUSTEREDNONCLUSTERED
TRIGGERTRIGGER
DayofYearDayofYear
NOT NOT
TRUNCATETRUNCATE
DBCCDBCC
ZERO ZERO
TRY_CONVERTTRY_CONVERT
TO RESERVEDEALLOCATE
NULLIFNULLIF
TSEQUALTSEQUAL
DECLAREDECLARE
DEROF
UNIONUNION
StandardDEFAULT
OFF
UNIQUEUNIQUE
DELETE DELETE
COMPOSITION SETS
UNPIVOTUNPIVOT
REFUSABLE
EINON
UPDATEUPDATE
DESCDESC
OPENOPEN
UpdateUPDATETEXT
DiskDISK
OPENDATASOURCEOPENDATASOURCE
UseUSE
DISTINCTDISTINCT
OPENQUERYOPENQUERY
USERUSER
DISTRIBUTED
OPENROWSETOPENROWSET
Values ​​VALUES
DOUBLEDOUBLE
OPENXMLOPENXML
VARYINGVARYING
DROPDROP
OPTIONOPTION
VIEWVIEW
DUMPDUMP
OROR
WAITFORWAITFOR
ELSEELSE
UMORDER
Week Week
ENDING
EXTERIOR OUTER
WeekdayWeekday
ERRLVLERRLVL
OVEROVER
WHENWHEN
ESCAPEESCAPE
PERCENTPERCENT
WHEREWHERE
EXCEPT EXCEPT
PIVOTPIVOT
DURING WHILE
EXECEXEC
PLAN PLAN
WITHWITH
RunEXECUTE
PRECISIONPRECISION
WITHIN THE GROUP WITHIN GROUP
EXISTSEXISTS
PRIMARYPRIMARY
WRITETEXTWRITETEXT
EXITEXIT
PrintPRINT
YearYear
EXTERNAL
PROCPROC
Yes
FETCHFETCH
Procedure PROCEDURE
YesNoYesNo
FileFILE
PUBLICPUBLIC

ODBC reserved keywords

Additionally, the ISO standard defines a list of reserved keywords. Avoid using ISO reserved keywords for object names and identifiers. The ODBC reserved keyword list, shown in the following table, is the same as the ISO reserved keyword list.

The following words are reserved for use in ODBC function calls. These words do not limit the minimum SQL grammar; however, to ensure compatibility with drivers that support the core SQL grammar, applications should avoid these keywords. These words do not constrain the minimum SQL grammar; However, to ensure compatibility with drivers that support the core SQL grammar, applications should avoid using these keywords.

This is the current list of ODBC reserved keywords.

ABSOLUTE ABSOLUTE
EXECEXEC
OVERLAP OVERLAPS
ActionACTION
RunEXECUTE
PADPAD
ADAADA
EXISTSEXISTS
PARTIAL PARTIAL
ADDADD
EXTERNAL
PASCALPASCAL
EVERYONE
EXTRACTEXTRACT
POSITION POSITION
ASSIGN ALLOCATE
FALSEFALSE
PRECISIONPRECISION
AGE
FETCHFETCH
PREPAREPREPARE
UNDAND
FIRSTFIRST
KEEP PRESERVE
ANYANY
FLOATFLOAT
PRIMARYPRIMARY
AREARE
FOR FOR
PRE-PRIOR
ASAS
FOREIGNFOREIGN
PRIVILEGESPRIVILEGES
ASCASC
FORTRANFORTRAN
Procedure PROCEDURE
ASSERTION ASSERTION
FOUND FOUND
PUBLICPUBLIC
ATAT
FROMFROM
Read READ
AUTHORIZATION AUTHORIZATION
COMPLETEFULL
REAL REAL
AVGAVG
GETGET
REFERENCESREFERENCES
BEGINNING
GLOBAL GLOBAL
RELATIVE RELATIVE
BETWEEN BETWEEN
Switch to GO
RESTRICTRESTRICT
BITBIT
GOTOGOTO
REVOKEREVOKE
BIT_LENGTHBIT_LENGTH
GRANTGRANT
RIGHTRIGHT
BOTHBOTH
GroupGROUP
ROLLBACKROLLBACK
BYBY
HAVINGHAVING
LinesROWS
CASCADECASCADE
HOURHOUR
SCHEME
CASCADED
IdentityIDENTITY
Scroll SCROLL
FallCASE
DIRECT IMMEDIATE
SECONDSECOND
GussCAST
ININ
IN SECTION
CATALOGCATALOG
INCLUDE
SELECTSELECT
CHARCHAR
INDEX INDEX
SESSION
CHAR_LENGTHCHAR_LENGTH
IndicatorINDICATOR
SESSION_USERSESSION_USER
CHARACTERCHARACTER
INITIAL INITIALLY
SETSET
CHARACTER_LENGTHCHARACTER_LENGTH
INSIDE
SIZESIZE
CHECK CHECK
INPUTINPUT
SMALLINTSMALLINT
CLOSECLOSE
INSENSITIVE INSENSITIVE
SOMESOME
COALESCECOALESCE
INSERT
SPACEBAR
COLLATECOLLATE
INTINT
SQLSQL
COLLATIONCOLLATION
INTEGER INTEGER
SQLCASQLCA
ColumnCOLUMN
INTERSECTINTERSECT
SQLCODESQLCODE
COMMITCOMMIT
INTERVAL INTERVAL
SQLERRORSQLERROR
CONNECTCONNECT
INTOINTO
SQLSTATESQLSTATE
CONNECTIONCONNECTION
ISTIS
SQLWARNINGSQLWARNING
Constraint CONSTRAINT
ISOLATION ISOLATION
SUBSTRING SUBSTRING
LimitationsCONSTRAINTS
JOIN
Sum
CONTINUES TO CONTINUE
KeyKEY
SYSTEM_USERSYSTEM_USER
CONVERTCONVERT
LANGUAGELANGUAGE
TABLETABLE
APPROPRIATE CORRESPONDING
LOAD LOAD
TEMPORARYTEMPORARY
COUNTCOUNT
LEADING LEADING
DANNTHEN
CREATECREATE
LinksLEFT
ZeitTIME
OVERALL DECROSS
LevelLEVEL
TIMESTAMPTIMESTAMP
CURRENT CURRENT
WIELIKE
TIMEZONE_HOURTIMEZONE_HOUR
CURRENT_DATECURRENT_DATE
LOCAL LOCAL
TIMEZONE_MINUTETIMEZONE_MINUTE
CURRENT_TIMECURRENT_TIME
LOWERLOWER
TOTO
CURRENT_TIMESTAMPCURRENT_TIMESTAMP
MATCHMATCH
TRAILING TRAILING
CURRENT_USERCURRENT_USER
MAXMAX
TRANSACTIONTRANSACTION
CURSORCURSOR
MINMIN
TRANSLATETRANSLATE
DATEDATE
MINUTE MINUTE
TRANSLATION TRANSLATION
DAYDAY
ModuleMODULE
TRIMTRIM
TO RESERVEDEALLOCATE
MONTHMONTH
TRUETRUE
DECDEC
Names NAMES
UNIONUNION
DECIMALDECIMAL
NATIONAL NATIONAL
UNIQUEUNIQUE
DECLAREDECLARE
NATURAL
UNKNOWNUNKNOWN
StandardDEFAULT
NCHARNCHAR
UPDATEUPDATE
DEFERRABLEDEFERRABLE
NEXT
UPPERUPPER
DELAYED DEFERRED
NO NO
USAGEUSAGE
DELETE DELETE
NO ONE
USERUSER
DESCDESC
NOT NOT
USINGUSING
DESCRIPTIVE DESCRIBE
ZERO ZERO
WertVALUE
Description DESCRIPTOR
NULLIFNULLIF
Values ​​VALUES
DiagnosisDIAGNOSTICS
NUMERIC NUMERIC
VARCHARVARCHAR
DISCONNECTDISCONNECT
OCTET_LENGTHOCTET_LENGTH
VARYINGVARYING
DISTINCTDISTINCT
DEROF
VIEWVIEW
DOMAIN DOMAIN
EINON
WHENWHEN
DOUBLEDOUBLE
ONLY
WHENEVERWHENEVER
DROPDROP
OPENOPEN
WHEREWHERE
ELSEELSE
OPTIONOPTION
WITHWITH
ENDING
OROR
WorkWORK
END-EXECEND-EXEC
UMORDER
WritingWRITE
ESCAPEESCAPE
EXTERIOR OUTER
YEARYEAR
EXCEPT EXCEPT
OUTPUTOUTPUT
ZONEZONE
ExceptionEXCEPTION

Future keywords

The following keywords could be reserved in future releases of SQL Server as new features are implemented. Avoid using these words as identifiers. Consider avoiding the use of these words as identifiers.

ABSOLUTE ABSOLUTE
HOSTHOST
RELATIVE RELATIVE
ActionACTION
HOURHOUR
RELEASERELEASE
ADMINADMIN
IGNOREIGNORE
Result RESULT
AFTER
DIRECTIME MEDIATE
GIBTRETURNS
Aggregate AGGREGATE
IndicatorINDICATOR
ROLES
ALIASALIAS
INITIALIZE INITIALIZE
ROLLUPROLLUP
ASSIGN ALLOCATE
INITIAL INITIALLY
ROUTINE ROUTINE
AREARE
INOUTINOUT
LineROW
ARRAYARRAY
INPUTINPUT
LinesROWS
SENSITIVE AS SENSITIVES
INTINT
SAVEPOINTSAVEPOINT
ASSERTION ASSERTION
INTEGER INTEGER
Scroll SCROLL
ASYMMETRICASYMMETRIC
CUTTING QUANTITY INTERSECTION
AreaSCOPE
ATAT
INTERVAL INTERVAL
SearchSEARCH
AtomATOMIC
ISOLATION ISOLATION
SECONDSECOND
PRE-FORE
CURRENT ITERATE
IN SECTION
BINARYBINARY
LANGUAGELANGUAGE
CONFIDENTIALSENSITIVE
BITBIT
LARGE LARGE
SequenceSEQUENCE
BLOB-BLOB
LOAD LOAD
SESSION
BOOLEANBOOLEAN
Side LATERAL
LEGTSETS
BOTHBOTH
LEADING LEADING
SIMILAR SIMILAR
WidthBREADTH
LESS LESS
SIZESIZE
CallCALL
LevelLEVEL
SMALLINTSMALLINT
CALLED
LIKE_REGEXLIKE_REGEX
SPACEBAR
CARDINALITY
Limit value LIMIT
CERTAIN SPECIFIC
CASCADED
LNLN
SPECIFICtypeSPECIFICTYPE
GussCAST
LOCAL LOCAL
SQLSQL
CATALOGCATALOG
LOCALTIMELOCALTIME
SQLEXCEPTION