Back

SQL Server reserved words

Structured Query Language (SQL) is a programming language used to communicate with a database. Within SQL, certain words are reserved, which means you cannot use these words as an SQL identifier (such as the name for a table, a column, an AS alias, or other entity).

Reserved words in SQL Server

SQL reserved words
ABSOLUTECURRENT_USERGROUPONSOME
ACTIONCURSORHAVINGONLYSPACE
ADADATABASEHOLDLOCKOPENSQL
ADDDATEHOUROPENDATASOURCESQLCA
ALLDAYIDENTITYOPENQUERYSQLCODE
ALLOCATEDBCCIDENTITY_INSERTOPENROWSETSQLERROR
ALTERDEALLOCATEIDENTITYCOLOPENXMLSQLSTATE
ANDDECIFOPTIONSQLWARNING
ANYDECIMALIMMEDIATEORSTATISTICS
AREDECLAREINORDERSUBSTRING
ASDEFAULTINCLUDEOUTERSUM
ASCDEFERRABLEINDEXOUTPUTSYSTEM_USER
ASSERTIONDEFERREDINDICATOROVERTABLE
ATDELETEINITIALLYOVERLAPSTASKSTATUS
AUTHORIZATIONDENYINNERPADTEMPORARY
AVGDESCINPUTPARTIALTEXTSIZE
BACKUPDESCRIBEINSENSITIVEPASCALTHEN
BEGINDESCRIPTORINSERTPERCENTTIME
BETWEENDIAGNOSTICSINTPLANTIMESTAMP
BITDISCONNECTINTEGERPOSITIONTIMEZONE_HOUR
BIT_LENGTHDISKINTERSECTPRECISIONTIMEZONE_MINUTE
BOTHDISTINCTINTERVALPREPARETO
BREAKDISTRIBUTEDINTOPRESERVETOP
BROWSEDOMAINISPRIMARYTRAILING
BULKDOUBLEISOLATIONPRINTTRAN
BYDROPJOINPRIORTRANSACTION
CASCADEDUMMYKEYPRIVILEGESTRANSLATE
CASCADEDDUMPKILLPROCTRANSLATION
CASEELSELANGUAGEPROCEDURETRIGGER
CASTENDLASTPUBLICTRIM
CATALOGEND-EXECLEADINGRAISERRORTRUE
CHARERRLVLLEFTREADTRUNCATE
CHAR_LENGTHESCAPELEVELREADTEXTTSEQUAL
CHARACTEREXCEPTLIKEREALUNION
CHARACTER_LENGTHEXCEPTIONLINENORECONFIGUREUNIQUE
CHECKEXECLOADREFERENCESUNKNOWN
CHECKPOINTEXECUTELOCALRELATIVEUPDATE
CLOSEEXISTSLOWERREPLICATIONUPDATETEXT
CLUSTEREDEXITMATCHRESTOREUPPER
COALESCEEXTERNALMAXRESTRICTUSAGE
COLLATEEXTRACTMINRETURNUSE
COLLATIONFALSEMINUTEREVOKEUSER
COLUMNFETCHMODULERIGHTUSING
COMMITFILEMONTHROLLBACKVALUE
COMPUTEFILLFACTORNAMESROWCOUNTVALUES
CONNECTFIRSTNATIONALROWGUIDCOLVARCHAR
CONNECTIONFLOATNATURALROWSVARYING
CONSTRAINTFORNCHARRULEVIEW
CONSTRAINTSFOREIGNNEXTSAVEWAITFOR
CONTAINSFORTRANNOSCHEMAWHEN
CONTAINSTABLEFOUNDNOCHECKSCROLLWHENEVER
CONTINUEFREETEXTNONCLUSTEREDSECONDWHERE
CONVERTFREETEXTTABLENONESECTIONWHILE
CORRESPONDINGFROMNOTSELECTWITH
COUNTFULLNULLSESSIONWORK
CREATEFUNCTIONNULLIFSESSION_USERWRITE
CROSSGETNUMERICSETWRITETEXT
CURRENTGLOBALOCTET_LENGTHSETUSERYEAR
CURRENT_DATEGOOFSHUTDOWNZONE
CURRENT_TIMEGOTOOFFSIZE
CURRENT_TIMESTAMPGRANTOFFSETSSMALLINT
Related Articles

InTechnical resources

InFundamentals of Blue

InTechnical resources

InData sync tool (DST) guide

Back to top

Copyright © 2025

Explorance Inc. All rights reserved.