Welcome

首页 / 数据库 / SQLServer / 数据库 关键字一览表

数据库 关键字:
为了避免在数据库表结构设计过程中使用系统保留关键字我们必须知道数据库存在哪些关键字,接下来会列出mysql、oracle、sqlserver三个数据库各自的保留关键字。
Mysql
http://dev.mysql.com/doc/refman/5.7/en/keywords.html
ACCESSIBLE (R)ACCOUNT[a]ACTION
ADD (R)AFTERAGAINST
AGGREGATEALGORITHMALL (R)
ALTER (R)ALWAYS[b]ANALYSE
ANALYZE (R)AND (R)ANY
AS (R)ASC (R)ASCII
ASENSITIVE (R)ATAUTOEXTEND_SIZE
AUTO_INCREMENTAVGAVG_ROW_LENGTH
BACKUPBEFORE (R)BEGIN
BETWEEN (R)BIGINT (R)BINARY (R)
BINLOGBITBLOB (R)
BLOCKBOOLBOOLEAN
BOTH (R)BTREEBY (R)
BYTECACHECALL (R)
CASCADE (R)CASCADEDCASE (R)
CATALOG_NAMECHAINCHANGE (R)
CHANGEDCHANNEL[c]CHAR (R)
CHARACTER (R)CHARSETCHECK (R)
CHECKSUMCIPHERCLASS_ORIGIN
CLIENTCLOSECOALESCE
CODECOLLATE (R)COLLATION
COLUMN (R)COLUMNSCOLUMN_FORMAT
COLUMN_NAMECOMMENTCOMMIT
COMMITTEDCOMPACTCOMPLETION
COMPRESSEDCOMPRESSION[d]CONCURRENT
CONDITION (R)CONNECTIONCONSISTENT
CONSTRAINT (R)CONSTRAINT_CATALOGCONSTRAINT_NAME
CONSTRAINT_SCHEMACONTAINSCONTEXT
CONTINUE (R)CONVERT (R)CPU
CREATE (R)CROSS (R)CUBE
CURRENTCURRENT_DATE (R)CURRENT_TIME (R)
CURRENT_TIMESTAMP (R)CURRENT_USER (R)CURSOR (R)
CURSOR_NAMEDATADATABASE (R)
DATABASES (R)DATAFILEDATE
DATETIMEDAYDAY_HOUR (R)
DAY_MICROSECOND (R)DAY_MINUTE (R)DAY_SECOND (R)
DEALLOCATEDEC (R)DECIMAL (R)
DECLARE (R)DEFAULT (R)DEFAULT_AUTH
DEFINERDELAYED (R)DELAY_KEY_WRITE
DELETE (R)DESC (R)DESCRIBE (R)
DES_KEY_FILEDETERMINISTIC (R)DIAGNOSTICS
DIRECTORYDISABLEDISCARD
DISKDISTINCT (R)DISTINCTROW (R)
DIV (R)DODOUBLE (R)
DROP (R)DUAL (R)DUMPFILE
DUPLICATEDYNAMICEACH (R)
ELSE (R)ELSEIF (R)ENABLE
ENCLOSED (R)ENCRYPTION[e]END
ENDSENGINEENGINES
ENUMERRORERRORS
ESCAPEESCAPED (R)EVENT
EVENTSEVERYEXCHANGE
EXECUTEEXISTS (R)EXIT (R)
EXPANSIONEXPIREEXPLAIN (R)
EXPORTEXTENDEDEXTENT_SIZE
FALSE (R)FASTFAULTS
FETCH (R)FIELDSFILE
FILE_BLOCK_SIZE[f]FILTER[g]FIRST
FIXEDFLOAT (R)FLOAT4 (R)
FLOAT8 (R)FLUSHFOLLOWS[h]
FOR (R)FORCE (R)FOREIGN (R)
FORMATFOUNDFROM (R)
FULLFULLTEXT (R)FUNCTION
GENERALGENERATED[i] (R)GEOMETRY
GEOMETRYCOLLECTIONGET (R)GET_FORMAT
GLOBALGRANT (R)GRANTS
GROUP (R)GROUP_REPLICATION[j]HANDLER
HASHHAVING (R)HELP
HIGH_PRIORITY (R)HOSTHOSTS
HOURHOUR_MICROSECOND (R)HOUR_MINUTE (R)
HOUR_SECOND (R)IDENTIFIEDIF (R)
IGNORE (R)IGNORE_SERVER_IDSIMPORT
IN (R)INDEX (R)INDEXES
INFILE (R)INITIAL_SIZEINNER (R)
INOUT (R)INSENSITIVE (R)INSERT (R)
INSERT_METHODINSTALLINSTANCE[k]
INT (R)INT1 (R)INT2 (R)
INT3 (R)INT4 (R)INT8 (R)
INTEGER (R)INTERVAL (R)INTO (R)
INVOKERIOIO_AFTER_GTIDS (R)
IO_BEFORE_GTIDS (R)IO_THREADIPC
IS (R)ISOLATIONISSUER
ITERATE (R)JOIN (R)JSON[l]
KEY (R)KEYS (R)KEY_BLOCK_SIZE
KILL (R)LANGUAGELAST
LEADING (R)LEAVE (R)LEAVES
LEFT (R)LESSLEVEL
LIKE (R)LIMIT (R)LINEAR (R)
LINES (R)LINESTRINGLIST
LOAD (R)LOCALLOCALTIME (R)
LOCALTIMESTAMP (R)LOCK (R)LOCKS
LOGFILELOGSLONG (R)
LONGBLOB (R)LONGTEXT (R)LOOP (R)
LOW_PRIORITY (R)MASTERMASTER_AUTO_POSITION
MASTER_BIND (R)MASTER_CONNECT_RETRYMASTER_DELAY
MASTER_HEARTBEAT_PERIODMASTER_HOSTMASTER_LOG_FILE
MASTER_LOG_POSMASTER_PASSWORDMASTER_PORT
MASTER_RETRY_COUNTMASTER_SERVER_IDMASTER_SSL
MASTER_SSL_CAMASTER_SSL_CAPATHMASTER_SSL_CERT
MASTER_SSL_CIPHERMASTER_SSL_CRLMASTER_SSL_CRLPATH
MASTER_SSL_KEYMASTER_SSL_VERIFY_SERVER_CERT (R)MASTER_TLS_VERSION[m]
MASTER_USERMATCH (R)MAXVALUE (R)
MAX_CONNECTIONS_PER_HOURMAX_QUERIES_PER_HOURMAX_ROWS
MAX_SIZEMAX_STATEMENT_TIME[n]MAX_UPDATES_PER_HOUR
MAX_USER_CONNECTIONSMEDIUMMEDIUMBLOB (R)
MEDIUMINT (R)MEDIUMTEXT (R)MEMORY
MERGEMESSAGE_TEXTMICROSECOND
MIDDLEINT (R)MIGRATEMINUTE
MINUTE_MICROSECOND (R)MINUTE_SECOND (R)MIN_ROWS
MOD (R)MODEMODIFIES (R)
MODIFYMONTHMULTILINESTRING
MULTIPOINTMULTIPOLYGONMUTEX
MYSQL_ERRNONAMENAMES
NATIONALNATURAL (R)NCHAR
NDBNDBCLUSTERNEVER[o]
NEWNEXTNO
NODEGROUPNONBLOCKING[p]NONE
NOT (R)NO_WAITNO_WRITE_TO_BINLOG (R)
NULL (R)NUMBERNUMERIC (R)
NVARCHAROFFSETOLD_PASSWORD[q]
ON (R)ONEONLY
OPENOPTIMIZE (R)OPTIMIZER_COSTS[r] (R)
OPTION (R)OPTIONALLY (R)OPTIONS
OR (R)ORDER (R)OUT (R)
OUTER (R)OUTFILE (R)OWNER
PACK_KEYSPAGEPARSER
PARSE_GCOL_EXPR[s]PARTIALPARTITION (R)
PARTITIONINGPARTITIONSPASSWORD
PHASEPLUGINPLUGINS
PLUGIN_DIRPOINTPOLYGON
PORTPRECEDES[t]PRECISION (R)
PREPAREPRESERVEPREV
PRIMARY (R)PRIVILEGESPROCEDURE (R)
PROCESSLISTPROFILEPROFILES
PROXYPURGE (R)QUARTER
QUERYQUICKRANGE (R)
READ (R)READS (R)READ_ONLY
READ_WRITE (R)REAL (R)REBUILD
RECOVERREDOFILEREDO_BUFFER_SIZE
REDUNDANTREFERENCES (R)REGEXP (R)
RELAYRELAYLOGRELAY_LOG_FILE
RELAY_LOG_POSRELAY_THREADRELEASE (R)
RELOADREMOVERENAME (R)
REORGANIZEREPAIRREPEAT (R)
REPEATABLEREPLACE (R)REPLICATE_DO_DB[u]
REPLICATE_DO_TABLE[v]REPLICATE_IGNORE_DB[w]REPLICATE_IGNORE_TABLE[x]
REPLICATE_REWRITE_DB[y]REPLICATE_WILD_DO_TABLE[z]REPLICATE_WILD_IGNORE_TABLE[aa]
REPLICATIONREQUIRE (R)RESET
RESIGNAL (R)RESTORERESTRICT (R)
RESUMERETURN (R)RETURNED_SQLSTATE
RETURNSREVERSEREVOKE (R)
RIGHT (R)RLIKE (R)ROLLBACK
ROLLUPROTATE[ab]ROUTINE
ROWROWSROW_COUNT
ROW_FORMATRTREESAVEPOINT
SCHEDULESCHEMA (R)SCHEMAS (R)
SCHEMA_NAMESECONDSECOND_MICROSECOND (R)
SECURITYSELECT (R)SENSITIVE (R)
SEPARATOR (R)SERIALSERIALIZABLE
SERVERSESSIONSET (R)
SHARESHOW (R)SHUTDOWN
SIGNAL (R)SIGNEDSIMPLE
SLAVESLOWSMALLINT (R)
SNAPSHOTSOCKETSOME
SONAMESOUNDSSOURCE
SPATIAL (R)SPECIFIC (R)SQL (R)
SQLEXCEPTION (R)SQLSTATE (R)SQLWARNING (R)
SQL_AFTER_GTIDSSQL_AFTER_MTS_GAPSSQL_BEFORE_GTIDS
SQL_BIG_RESULT (R)SQL_BUFFER_RESULTSQL_CACHE
SQL_CALC_FOUND_ROWS (R)SQL_NO_CACHESQL_SMALL_RESULT (R)
SQL_THREADSQL_TSI_DAYSQL_TSI_HOUR
SQL_TSI_MINUTESQL_TSI_MONTHSQL_TSI_QUARTER
SQL_TSI_SECONDSQL_TSI_WEEKSQL_TSI_YEAR
SSL (R)STACKEDSTART
STARTING (R)STARTSSTATS_AUTO_RECALC
STATS_PERSISTENTSTATS_SAMPLE_PAGESSTATUS
STOPSTORAGESTORED[ac] (R)
STRAIGHT_JOIN (R)STRINGSUBCLASS_ORIGIN
SUBJECTSUBPARTITIONSUBPARTITIONS
SUPERSUSPENDSWAPS
SWITCHESTABLE (R)TABLES
TABLESPACETABLE_CHECKSUMTABLE_NAME
TEMPORARYTEMPTABLETERMINATED (R)
TEXTTHANTHEN (R)
TIMETIMESTAMPTIMESTAMPADD
TIMESTAMPDIFFTINYBLOB (R)TINYINT (R)
TINYTEXT (R)TO (R)TRAILING (R)
TRANSACTIONTRIGGER (R)TRIGGERS
TRUE (R)TRUNCATETYPE
TYPESUNCOMMITTEDUNDEFINED
UNDO (R)UNDOFILEUNDO_BUFFER_SIZE
UNICODEUNINSTALLUNION (R)
UNIQUE (R)UNKNOWNUNLOCK (R)
UNSIGNED (R)UNTILUPDATE (R)
UPGRADEUSAGE (R)USE (R)
USERUSER_RESOURCESUSE_FRM
USING (R)UTC_DATE (R)UTC_TIME (R)
UTC_TIMESTAMP (R)VALIDATION[ad]VALUE
VALUES (R)VARBINARY (R)VARCHAR (R)
VARCHARACTER (R)VARIABLESVARYING (R)
VIEWVIRTUAL[ae] (R)WAIT
WARNINGSWEEKWEIGHT_STRING
WHEN (R)WHERE (R)WHILE (R)
WITH (R)WITHOUT[af]WORK
WRAPPERWRITE (R)X509
XAXID[ag]XML
XOR (R)YEARYEAR_MONTH (R)
ZEROFILL (R)  

Oracle
select * from v$reserved_words order by keyword asc
!!=&()*+,-./:;<<<<===>>>=@AABORTABSACCESSACCESSEDACCOUNTACOSACTIVATEACTIVE_COMPONENTACTIVE_FUNCTIONACTIVE_TAGADDADD_COLUMNADD_GROUPADD_MONTHSADJ_DATEADMINADMINISTERADMINISTRATORADVISEADVISORAFTERALIASALLALLOCATEALLOWALL_ROWSALTERALWAYSANALYZEANCILLARYANDAND_EQUALANTIJOINANYANYSCHEMAAPPENDAPPENDCHILDXMLAPPEND_VALUESAPPLYARCHIVEARCHIVELOGARRAYASASCASCIIASCIISTRASINASSEMBLYASSOCIATEASYNCASYNCHRONOUSATATANATAN2ATTRIBUTEATTRIBUTESAUDITAUTHENTICATEDAUTHENTICATIONAUTHIDAUTHORIZATIONAUTOAUTOALLOCATEAUTOEXTENDAUTOMATICAVAILABILITYAVGBACKUPBASICBASICFILEBATCHBECOMEBEFOREBEGINBEGIN_OUTLINE_DATABEHALFBETWEENBFILEBFILENAMEBIGFILEBINARYBINARY_DOUBLEBINARY_DOUBLE_INFINITYBINARY_DOUBLE_NANBINARY_FLOATBINARY_FLOAT_INFINITYBINARY_FLOAT_NANBINDINGBIND_AWAREBIN_TO_NUMBITANDBITMAPBITMAPSBITMAP_TREEBITSBLOBBLOCKBLOCKSBLOCKSIZEBLOCK_RANGEBODYBOTHBOUNDBRANCHBREADTHBROADCASTBUFFERBUFFER_CACHEBUFFER_POOLBUILDBULKBYBYPASS_RECURSIVE_CHECKBYPASS_UJVCBYTECACHECACHE_CBCACHE_INSTANCESCACHE_TEMP_TABLECALLCANCELCARDINALITYCASCADECASECASTCATEGORYCEILCELL_FLASH_CACHECERTIFICATECFILECHAINEDCHANGECHANGE_DUPKEY_ERROR_INDEXCHARCHARACTERCHARTOROWIDCHAR_CSCHECKCHECKPOINTCHECK_ACL_REWRITECHILDCHOOSECHRCHUNKCLASSCLEARCLOBCLONECLOSECLOSE_CACHED_OPEN_CURSORSCLUSTERCLUSTERING_FACTORCLUSTER_IDCLUSTER_PROBABILITYCLUSTER_SETCOALESCECOALESCE_SQCOARSECOLDCOLLECTCOLUMNCOLUMNARCOLUMNSCOLUMN_AUTH_INDICATORCOLUMN_STATSCOLUMN_VALUECOMMENTCOMMITCOMMITTEDCOMPACTCOMPATIBILITYCOMPILECOMPLETECOMPLIANCECOMPOSECOMPOSITECOMPOSITE_LIMITCOMPOUNDCOMPRESSCOMPUTECONCATCONFIRMCONFORMINGCONNECTCONNECT_BY_CB_WHR_ONLYCONNECT_BY_COMBINE_SWCONNECT_BY_COST_BASEDCONNECT_BY_ELIM_DUPSCONNECT_BY_FILTERINGCONNECT_BY_ISCYCLECONNECT_BY_ISLEAFCONNECT_BY_ROOTCONNECT_TIMECONSIDERCONSISTENTCONSTCONSTANTCONSTRAINTCONSTRAINTSCONTAINERCONTENTCONTENTSCONTEXTCONTINUECONTROLFILECONVERTCORRCORRUPTIONCORRUPT_XIDCORRUPT_XID_ALLCORR_KCORR_SCOSCOSHCOSTCOST_XML_QUERY_REWRITECOUNTCOVAR_POPCOVAR_SAMPCO_AUTH_INDCPU_COSTINGCPU_PER_CALLCPU_PER_SESSIONCRASHCREATECREATE_STORED_OUTLINESCREATIONCROSSCROSSEDITIONCSCONVERTCUBECUBE_GBCUME_DISTCUME_DISTMCURRENTCURRENTVCURRENT_DATECURRENT_SCHEMACURRENT_TIMECURRENT_TIMESTAMPCURRENT_USERCURSORCURSOR_SHARING_EXACTCURSOR_SPECIFIC_SEGMENTCVCYCLEDDANGLINGDATADATABASEDATABASE_DEFAULTDATAFILEDATAFILESDATAOBJNODATAOBJ_TO_PARTITIONDATEDATE_MODEDAYDBADBA_RECYCLEBINDBMS_STATSDBTIMEZONEDB_ROLE_CHANGEDB_VERSIONDDLDEALLOCATEDEBUGDEBUGGERDECDECIMALDECLAREDECODEDECOMPOSEDECRDECREMENTDECRYPTDEDUPLICATEDEFAULTDEFAULTSDEFERRABLEDEFERREDDEFINEDDEFINERDEGREEDELAYDELETEDELETEXMLDEMANDDENSE_RANKDENSE_RANKMDEPENDENTDEPTHDEQUEUEDEREFDEREF_NO_REWRITEDESCDETACHEDDETERMINESDICTIONARYDIMENSIONDIRECTORYDIRECT_LOADDISABLEDISABLE_PRESETDISABLE_RPKEDISALLOWDISASSOCIATEDISCONNECTDISKDISKGROUPDISKSDISMOUNTDISTINCTDISTINGUISHEDDISTRIBUTEDDMLDML_UPDATEDOCFIDELITYDOCUMENTDOMAIN_INDEX_FILTERDOMAIN_INDEX_NO_SORTDOMAIN_INDEX_SORTDOUBLEDOWNGRADEDRIVING_SITEDROPDROP_COLUMNDROP_GROUPDST_UPGRADE_INSERT_CONVDUMPDYNAMICDYNAMIC_SAMPLINGDYNAMIC_SAMPLING_EST_CDNEEACHEDITIONEDITIONINGEDITIONSELEMENTELIMINATE_JOINELIMINATE_OBYELIMINATE_OUTER_JOINELSEEMPTYEMPTY_BLOBEMPTY_CLOBENABLEENABLE_PRESETENCODINGENCRYPTENCRYPTIONENDEND_OUTLINE_DATAENFORCEENFORCEDENQUEUEENTERPRISEENTITYESCAPINGENTRYERRORERRORSERROR_ARGUMENTERROR_ON_OVERLAP_TIMEESCAPEESTIMATEEVALNAMEEVALUATIONEVENTSEVERYEXCEPTEXCEPTIONSEXCHANGEEXCLUDEEXCLUDINGEXCLUSIVEEXECUTEEXEMPTEXISTSEXISTSNODEEXPEXPAND_GSET_TO_UNIONEXPAND_TABLEEXPIREEXPLAINEXPLOSIONEXPORTEXPR_CORR_CHECKEXTENDSEXTENTEXTENTSEXTERNALEXTERNALLYEXTRAEXTRACTEXTRACTVALUEFACILITYFACTFACTORIZE_JOINFAILEDFAILED_LOGIN_ATTEMPTSFAILGROUPFALSEFASTFBTSCANFEATURE_IDFEATURE_SETFEATURE_VALUEFILEFILESYSTEM_LIKE_LOGGINGFILTERFINALFINEFINISHFIRSTFIRSTMFIRST_ROWSFIRST_VALUEFLAGGERFLASHBACKFLASH_CACHEFLOATFLOBFLOORFLUSHFOLDERFOLLOWINGFOLLOWSFORFORCEFORCE_XML_QUERY_REWRITEFOREIGNFOREVERFORWARDFREELISTFREELISTSFREEPOOLSFRESHFROMFROM_TZFULLFUNCTIONFUNCTIONSGGATHER_PLAN_STATISTICSGBY_CONC_ROLLUPGBY_PUSHDOWNGENERATEDGLOBALGLOBALLYGLOBAL_NAMEGLOBAL_TOPIC_ENABLEDGRANTGREATESTGROUPGROUPINGGROUPING_IDGROUPSGROUP_BYGROUP_IDGUARANTEEGUARANTEEDGUARDHHASHHASHKEYSHASH_AJHASH_SJHAVINGHEADERHEAPHELPHEXTORAWHEXTOREFHIDDENHIDEHIERARCHYHIGHHINTSET_BEGINHINTSET_ENDHOTHOURHWM_BROKEREDHYBRIDIDIDENTIFIEDIDENTIFIERIDENTITYIDGENERATORSIDLE_TIMEIFIGNOREIGNORE_OPTIM_EMBEDDED_HINTSIGNORE_ROW_ON_DUPKEY_INDEXIGNORE_WHERE_CLAUSEIMMEDIATEIMPACTIMPORTININCLUDEINCLUDE_VERSIONINCLUDINGINCRINCREMENTINCREMENTALINDENTINDEXINDEXEDINDEXESINDEXTYPEINDEXTYPESINDEX_ASCINDEX_COMBINEINDEX_DESCINDEX_FFSINDEX_FILTERINDEX_JOININDEX_ROWSINDEX_RRSINDEX_RSINDEX_RS_ASCINDEX_RS_DESCINDEX_SCANINDEX_SKIP_SCANINDEX_SSINDEX_SS_ASCINDEX_SS_DESCINDEX_STATSINDICATORINFINITEINFORMATIONALINITCAPINITIALINITIALIZEDINITIALLYINITRANSINLINEINLINE_XMLTYPE_NTINNERINSERTINSERTCHILDXMLINSERTCHILDXMLAFTERINSERTCHILDXMLBEFOREINSERTXMLAFTERINSERTXMLBEFOREINSTANCEINSTANCESINSTANTIABLEINSTANTLYINSTEADINSTRINSTR2INSTR4INSTRBINSTRCINTINTEGERINTERMEDIATEINTERNAL_CONVERTINTERNAL_USEINTERPRETEDINTERSECTINTERVALINTOINVALIDATEINVISIBLEIN_MEMORY_METADATAIN_XQUERYISISOLATIONISOLATION_LEVELITERATEITERATION_NUMBERJAVAJOBJOINKKEEPKEEP_DUPLICATESKERBEROSKEYKEYSKEYSIZEKEY_LENGTHKILLLAGLASTLAST_DAYLAST_VALUELATERALLAYERLDAP_REGISTRATIONLDAP_REGISTRATION_ENABLEDLDAP_REG_SYNC_INTERVALLEADLEADINGLEASTLEFTLENGTHLENGTH2LENGTH4LENGTHBLENGTHCLESSLEVELLEVELSLIBRARYLIFELIFETIMELIKELIKE2LIKE4LIKECLIKE_EXPANDLIMITLINKLISTLISTAGGLNLNNVLLOBLOBNVLLOBSLOCALLOCALTIMELOCALTIMESTAMPLOCAL_INDEXESLOCATIONLOCATORLOCKLOCKEDLOGLOGFILELOGFILESLOGGINGLOGICALLOGICAL_READS_PER_CALLLOGICAL_READS_PER_SESSIONLOGOFFLOGONLONGLOWLOWERLPADLTRIMMMAINMAKE_REFMANAGEMANAGEDMANAGEMENTMANUALMAPPINGMASTERMATCHEDMATERIALIZEMATERIALIZEDMAXMAXARCHLOGSMAXDATAFILESMAXEXTENTSMAXIMIZEMAXINSTANCESMAXLOGFILESMAXLOGHISTORYMAXLOGMEMBERSMAXSIZEMAXTRANSMAXVALUEMEASUREMEASURESMEDIANMEDIUMMEMBERMEMORYMERGEMERGE$ACTIONSMERGE_AJMERGE_CONST_ONMERGE_SJMETHODMIGRATEMIGRATIONMINMINEXTENTSMINIMIZEMINIMUMMININGMINUSMINUS_NULLMINUTEMINVALUEMIRRORMIRRORCOLDMIRRORHOTMLSLABELMODMODEMODELMODEL_COMPILE_SUBQUERYMODEL_DONTVERIFY_UNIQUENESSMODEL_DYNAMIC_SUBQUERYMODEL_MIN_ANALYSISMODEL_NO_ANALYSISMODEL_PBYMODEL_PUSH_REFMODIFYMONITORMONITORINGMONTHMONTHS_BETWEENMOUNTMOUNTPATHMOVEMOVEMENTMULTISETMV_MERGENAMENAMEDNAMESPACENANNANVLNATIONALNATIVENATIVE_FULL_OUTER_JOINNATURALNAVNCHARNCHAR_CSNCHRNCLOBNEEDEDNESTEDNESTED_TABLE_FAST_INSERTNESTED_TABLE_GET_REFSNESTED_TABLE_IDNESTED_TABLE_SET_REFSNESTED_TABLE_SET_SETIDNETWORKNEVERNEWNEW_TIMENEXTNEXT_DAYNLJ_BATCHINGNLJ_INDEX_FILTERNLJ_INDEX_SCANNLJ_PREFETCHNLSSORTNLS_CALENDARNLS_CHARACTERSETNLS_CHARSET_DECL_LENNLS_CHARSET_IDNLS_CHARSET_NAMENLS_COMPNLS_CURRENCYNLS_DATE_FORMATNLS_DATE_LANGUAGENLS_INITCAPNLS_ISO_CURRENCYNLS_LANGNLS_LANGUAGENLS_LENGTH_SEMANTICSNLS_LOWERNLS_NCHAR_CONV_EXCPNLS_NUMERIC_CHARACTERSNLS_SORTNLS_SPECIAL_CHARSNLS_TERRITORYNLS_UPPERNL_AJNL_SJNONOAPPENDNOARCHIVELOGNOAUDITNOCACHENOCOMPRESSNOCPU_COSTINGNOCYCLENODELAYNOENTITYESCAPINGNOFORCENOGUARANTEENOLOCALNOLOGGINGNOMAPPINGNOMAXVALUENOMINIMIZENOMINVALUENOMONITORINGNONENONSCHEMANOORDERNOOVERRIDENOPARALLELNOPARALLEL_INDEXNORELYNOREPAIRNORESETLOGSNOREVERSENOREWRITENORMALNOROWDEPENDENCIESNOSCHEMACHECKNOSEGMENTNOSORTNOSTRICTNOSWITCHNOTNOTHINGNOTIFICATIONNOVALIDATENOWAITNO_ACCESSNO_BASETABLE_MULTIMV_REWRITENO_BIND_AWARENO_BUFFERNO_CARTESIANNO_CHECK_ACL_REWRITENO_COALESCE_SQNO_CONNECT_BY_CB_WHR_ONLYNO_CONNECT_BY_COMBINE_SWNO_CONNECT_BY_COST_BASEDNO_CONNECT_BY_ELIM_DUPSNO_CONNECT_BY_FILTERINGNO_COST_XML_QUERY_REWRITENO_CPU_COSTINGNO_DOMAIN_INDEX_FILTERNO_DST_UPGRADE_INSERT_CONVNO_ELIMINATE_JOINNO_ELIMINATE_OBYNO_ELIMINATE_OUTER_JOINNO_EXPANDNO_EXPAND_GSET_TO_UNIONNO_EXPAND_TABLENO_FACTNO_FACTORIZE_JOINNO_FILTERINGNO_GBY_PUSHDOWNNO_INDEXNO_INDEX_FFSNO_INDEX_SSNO_LOADNO_MERGENO_MODEL_PUSH_REFNO_MONITORNO_MONITORINGNO_MULTIMV_REWRITENO_NATIVE_FULL_OUTER_JOINNO_NLJ_BATCHINGNO_NLJ_PREFETCHNO_ORDER_ROLLUPSNO_OUTER_JOIN_TO_INNERNO_PARALLELNO_PARALLEL_INDEXNO_PARTIAL_COMMITNO_PLACE_DISTINCTNO_PLACE_GROUP_BYNO_PQ_MAPNO_PRUNE_GSETSNO_PULL_PREDNO_PUSH_PREDNO_PUSH_SUBQNO_PX_JOIN_FILTERNO_QKN_BUFFNO_QUERY_TRANSFORMATIONNO_REF_CASCADENO_RESULT_CACHENO_REWRITENO_SEMIJOINNO_SET_TO_JOINNO_SQL_TUNENO_STAR_TRANSFORMATIONNO_STATEMENT_QUEUINGNO_STATS_GSETSNO_SUBQUERY_PRUNINGNO_SUBSTRB_PADNO_SWAP_JOIN_INPUTSNO_TEMP_TABLENO_TRANSFORM_DISTINCT_AGGNO_UNNESTNO_USE_HASHNO_USE_HASH_AGGREGATIONNO_USE_INVISIBLE_INDEXESNO_USE_MERGENO_USE_NLNO_XMLINDEX_REWRITENO_XMLINDEX_REWRITE_IN_SELECTNO_XML_DML_REWRITENO_XML_QUERY_REWRITENTH_VALUENTILENULLNULLIFNULLSNUMBERNUMERICNUMTODSINTERVALNUMTOYMINTERVALNUM_INDEX_KEYSNVARCHAR2NVLNVL2OBJECTOBJECTTOXMLOBJNOOBJNO_REUSEOCCURENCESOFOFFOFFLINEOIDOIDINDEXOLAPOLDOLD_PUSH_PREDOLTPONONLINEONLYOPAQUEOPAQUE_TRANSFORMOPAQUE_XCANONICALOPCODEOPENOPERATIONSOPERATOROPTIMALOPTIMIZER_FEATURES_ENABLEOPTIMIZER_GOALOPTIONOPT_ESTIMATEOPT_PARAMORORADEBUGORA_BRANCHORA_CHECKACLORA_DST_AFFECTEDORA_DST_CONVERTORA_DST_ERRORORA_GET_ACLIDSORA_GET_PRIVILEGESORA_HASHORA_ROWSCNORA_ROWSCN_RAWORA_ROWVERSIONORA_TABVERSIONORDERORDEREDORDERED_PREDICATESORDINALITYORGANIZATIONOR_EXPANDOR_PREDICATESOTHEROUTEROUTER_JOIN_TO_INNEROUTLINEOUTLINE_LEAFOUT_OF_LINEOVEROVERFLOWOVERFLOW_NOMOVEOVERLAPSOWNOWNEROWNERSHIPPPACKAGEPACKAGESPARALLELPARALLEL_INDEXPARAMPARAMETERSPARENTPARITYPART$NUM$INSTPARTIALLYPARTITIONPARTITIONSPARTITION_HASHPARTITION_LISTPARTITION_RANGEPASSINGPASSWORDPASSWORD_GRACE_TIMEPASSWORD_LIFE_TIMEPASSWORD_LOCK_TIMEPASSWORD_REUSE_MAXPASSWORD_REUSE_TIMEPASSWORD_VERIFY_FUNCTIONPATHPATHSPBL_HS_BEGINPBL_HS_ENDPCTFREEPCTINCREASEPCTTHRESHOLDPCTUSEDPCTVERSIONPENDINGPERCENTPERCENTILE_CONTPERCENTILE_DISCPERCENT_RANKPERCENT_RANKMPERFORMANCEPERMANENTPERMISSIONPFILEPHYSICALPIKEYPIVOTPIV_GBPIV_SSFPLACE_DISTINCTPLACE_GROUP_BYPLANPLSCOPE_SETTINGSPLSQL_CCFLAGSPLSQL_CODE_TYPEPLSQL_DEBUGPLSQL_OPTIMIZE_LEVELPLSQL_WARNINGSPOINTPOLICYPOST_TRANSACTIONPOWERPOWERMULTISETPOWERMULTISET_BY_CARDINALITYPQ_DISTRIBUTEPQ_MAPPQ_NOMAPPREBUILTPRECEDESPRECEDINGPRECISIONPRECOMPUTE_SUBQUERYPREDICATE_REORDERSPREDICTIONPREDICTION_BOUNDSPREDICTION_COSTPREDICTION_DETAILSPREDICTION_PROBABILITYPREDICTION_SETPREPAREPRESENTPRESENTNNVPRESENTVPRESERVEPRESERVE_OIDPREVIOUSPRIMARYPRIORPRIVATEPRIVATE_SGAPRIVILEGEPRIVILEGESPROCEDURALPROCEDUREPROCESSPROFILEPROGRAMPROJECTPROPAGATEPROTECTEDPROTECTIONPUBLICPULL_PREDPURGEPUSH_PREDPUSH_SUBQPX_GRANULEPX_JOIN_FILTERQB_NAMEQUERYQUERY_BLOCKQUEUEQUEUE_CURRQUEUE_ROWPQUIESCEQUORUMQUOTARANDOMRANDOM_LOCALRANGERANKRANKMRAPIDLYRATIO_TO_REPORTRAWRAWTOHEXRAWTONHEXRBARBO_OUTLINERDBAREADREADSREALREBALANCEREBUILDRECORDS_PER_BLOCKRECOVERRECOVERABLERECOVERYRECYCLERECYCLEBINREDOREDUCEDREDUNDANCYREFREFERENCEREFERENCEDREFERENCESREFERENCINGREFRESHREFTOHEXREF_CASCADE_CURSORREGEXP_COUNTREGEXP_INSTRREGEXP_LIKEREGEXP_REPLACEREGEXP_SUBSTRREGISTERREGR_AVGXREGR_AVGYREGR_COUNTREGR_INTERCEPTREGR_R2REGR_SLOPEREGR_SXXREGR_SXYREGR_SYYREGULARREJECTREKEYRELATIONALRELYREMAINDERREMOTE_MAPPEDREMOVERENAMEREPAIRREPEATREPLACEREPLICATIONREQUIREDRESETRESETLOGSRESIZERESOLVERESOLVERRESOURCERESPECTRESTORERESTORE_AS_INTERVALSRESTRICTRESTRICTEDRESTRICT_ALL_REF_CONSRESULT_CACHERESUMABLERESUMERETENTIONRETRY_ON_ROW_CHANGERETURNRETURNINGREUSEREVERSEREVOKEREWRITEREWRITE_OR_ERRORRIGHTROLEROLESROLLBACKROLLINGROLLUPROUNDROWROWDEPENDENCIESROWIDROWIDTOCHARROWIDTONCHARROWNUMROWSROW_LENGTHROW_NUMBERRPADRTRIMRULERULESSALTSAMPLESAVEPOINTSAVE_AS_INTERVALSSB4SCALESCALE_ROWSSCANSCAN_INSTANCESSCHEDULERSCHEMASCHEMACHECKSCNSCN_ASCENDINGSCOPESD_ALLSD_INHIBITSD_SHOWSEARCHSECONDSECUREFILESECUREFILE_DBASECURITYSEEDSEGMENTSEG_BLOCKSEG_FILESELECTSELECTIVITYSEMIJOINSEMIJOIN_DRIVERSEQUENCESEQUENCEDSEQUENTIALSERIALIZABLESERVERERRORSESSIONSESSIONS_PER_USERSESSIONTIMEZONESESSIONTZNAMESESSION_CACHED_CURSORSSETSETSSETTINGSSET_TO_JOINSEVERESHARESHAREDSHARED_POOLSHOWSHRINKSHUTDOWNSIBLINGSSIDSIGNSIGNAL_COMPONENTSIGNAL_FUNCTIONSIMPLESINSINGLESINGLETASKSINHSIZESKIPSKIP_EXT_OPTIMIZERSKIP_UNQ_UNUSABLE_IDXSKIP_UNUSABLE_INDEXESSMALLFILESMALLINTSNAPSHOTSOMESORTSOUNDEXSOURCESPACESPECIFICATIONSPFILESPLITSPREADSHEETSQLSQLLDRSQL_TRACESQRTSTALESTANDALONESTANDBYSTANDBY_MAX_DATA_DELAYSTARSTARTSTARTUPSTAR_TRANSFORMATIONSTATEMENTSSTATEMENT_IDSTATEMENT_QUEUINGSTATICSTATISTICSSTATS_BINOMIAL_TESTSTATS_CROSSTABSTATS_F_TESTSTATS_KS_TESTSTATS_MODESTATS_MW_TESTSTATS_ONE_WAY_ANOVASTATS_T_TEST_INDEPSTATS_T_TEST_INDEPUSTATS_T_TEST_ONESTATS_T_TEST_PAIREDSTATS_WSR_TESTSTDDEVSTDDEV_POPSTDDEV_SAMPSTOPSTORAGESTORESTREAMSSTRICTSTRINGSTRIPSTRIPE_COLUMNSSTRIPE_WIDTHSTRUCTURESUBMULTISETSUBPARTITIONSUBPARTITIONSSUBPARTITION_RELSUBQUERIESSUBQUERY_PRUNINGSUBSTITUTABLESUBSTRSUBSTR2SUBSTR4SUBSTRBSUBSTRCSUCCESSFULSUMSUMMARYSUPPLEMENTALSUSPENDSWAP_JOIN_INPUTSSWITCHSWITCHOVERSYNCSYNCHRONOUSSYNONYMSYSASMSYSAUXSYSDATESYSDBASYSOPERSYSTEMSYSTEM_DEFINEDSYSTIMESTAMPSYS_AUDITSYS_CHECKACLSYS_CONNECT_BY_PATHSYS_CONTEXTSYS_DBURIGENSYS_DL_CURSORSYS_DM_RXFORM_CHRSYS_DM_RXFORM_NUMSYS_DOM_COMPARESYS_DST_PRIM2SECSYS_DST_SEC2PRIMSYS_ET_BFILE_TO_RAWSYS_ET_BLOB_TO_IMAGESYS_ET_IMAGE_TO_BLOBSYS_ET_RAW_TO_BFILESYS_EXTPDTXTSYS_EXTRACT_UTCSYS_FBT_INSDELSYS_FILTER_ACLSSYS_GETTOKENIDSYS_GET_ACLIDSSYS_GET_PRIVILEGESSYS_GUIDSYS_MAKEXMLSYS_MAKE_XMLNODEIDSYS_MKXMLATTRSYS_OPTLOBPRBSCSYS_OPTXICMPSYS_OPTXQCASTASNQSYS_OP_ADT2BINSYS_OP_ADTCONSSYS_OP_ALSCRVALSYS_OP_ATGSYS_OP_BIN2ADTSYS_OP_BITVECSYS_OP_BL2RSYS_OP_BLOOM_FILTERSYS_OP_BLOOM_FILTER_LISTSYS_OP_C2CSYS_OP_CASTSYS_OP_CEGSYS_OP_CL2CSYS_OP_COMBINED_HASHSYS_OP_COMPSYS_OP_CONVERTSYS_OP_COUNTCHGSYS_OP_CSCONVSYS_OP_CSCONVTESTSYS_OP_CSRSYS_OP_CSX_PATCHSYS_OP_DECOMPSYS_OP_DESCENDSYS_OP_DISTINCTSYS_OP_DRASYS_OP_DUMPSYS_OP_ENFORCE_NOT_NULL$SYS_OP_EXTRACTSYS_OP_GROUPINGSYS_OP_GUIDSYS_OP_IIXSYS_OP_ITRSYS_OP_LBIDSYS_OP_LOBLOC2BLOBSYS_OP_LOBLOC2CLOBSYS_OP_LOBLOC2IDSYS_OP_LOBLOC2NCLOBSYS_OP_LOBLOC2TYPSYS_OP_LSVISYS_OP_LVLSYS_OP_MAKEOIDSYS_OP_MAP_NONNULLSYS_OP_MSRSYS_OP_NICOMBINESYS_OP_NIEXTRACTSYS_OP_NIISYS_OP_NIXSYS_OP_NOEXPANDSYS_OP_NTCIMG$SYS_OP_NUMTORAWSYS_OP_OIDVALUESYS_OP_OPNSIZESYS_OP_PARSYS_OP_PARGIDSYS_OP_PARGID_1SYS_OP_PAR_1SYS_OP_PIVOTSYS_OP_R2OSYS_OP_RAWTONUMSYS_OP_RDTMSYS_OP_REFSYS_OP_RMTDSYS_OP_ROWIDTOOBJSYS_OP_RPBSYS_OP_TOSETIDSYS_OP_TPRSYS_OP_TRTBSYS_OP_UNDESCENDSYS_OP_VECANDSYS_OP_VECBITSYS_OP_VECORSYS_OP_VECXORSYS_OP_VERSIONSYS_OP_VREFSYS_OP_VVDSYS_OP_XPTHATGSYS_OP_XPTHIDXSYS_OP_XPTHOPSYS_OP_XTXT2SQLTSYS_ORDERKEY_DEPTHSYS_ORDERKEY_MAXCHILDSYS_ORDERKEY_PARENTSYS_PARALLEL_TXNSYS_PATHID_IS_ATTRSYS_PATHID_IS_NMSPCSYS_PATHID_LASTNAMESYS_PATHID_LASTNMSPCSYS_PATH_REVERSESYS_PXQEXTRACTSYS_RID_ORDERSYS_ROW_DELTASYS_SC_2_XMLTSYS_SYNRCIREDOSYS_TYPEIDSYS_UMAKEXMLSYS_XMLANALYZESYS_XMLCONTAINSSYS_XMLCONVSYS_XMLEXNSURISYS_XMLGENSYS_XMLI_LOC_ISNODESYS_XMLI_LOC_ISTEXTSYS_XMLLOCATOR_GETSVALSYS_XMLNODEIDSYS_XMLNODEID_GETCIDSYS_XMLNODEID_GETLOCATORSYS_XMLNODEID_GETOKEYSYS_XMLNODEID_GETPATHIDSYS_XMLNODEID_GETPTRIDSYS_XMLNODEID_GETRIDSYS_XMLNODEID_GETSVALSYS_XMLNODEID_GETTIDSYS_XMLTRANSLATESYS_XMLTYPE2SQLSYS_XMLT_2_SCSYS_XQBASEURISYS_XQCASTABLEERRHSYS_XQCODEP2STRSYS_XQCODEPEQSYS_XQCON2SEQSYS_XQCONCATSYS_XQDELETESYS_XQDFLTCOLATIONSYS_XQDOCSYS_XQDOCURISYS_XQED4URISYS_XQENDSWITHSYS_XQERRSYS_XQERRHSYS_XQESHTMLURISYS_XQEXLOBVALSYS_XQEXSTWRPSYS_XQEXTRACTSYS_XQEXTRREFSYS_XQEXVALSYS_XQFB2STRSYS_XQFNBOOLSYS_XQFNCMPSYS_XQFNDATIMSYS_XQFNLNAMESYS_XQFNNMSYS_XQFNNSURISYS_XQFNPREDTRUTHSYS_XQFNQNMSYS_XQFNROOTSYS_XQFORMATNUMSYS_XQFTCONTAINSYS_XQFUNCRSYS_XQGETCONTENTSYS_XQINDXOFSYS_XQINSERTSYS_XQINSPFXSYS_XQIRI2URISYS_XQLANGSYS_XQLLNMFRMQNMSYS_XQMKNODEREFSYS_XQNILLEDSYS_XQNODENAMESYS_XQNORMSPACESYS_XQNORMUCODESYS_XQNSP4PFXSYS_XQNSPFRMQNMSYS_XQPFXFRMQNMSYS_XQPOLYABSSYS_XQPOLYADDSYS_XQPOLYCELSYS_XQPOLYCSTSYS_XQPOLYCSTBLSYS_XQPOLYDIVSYS_XQPOLYFLRSYS_XQPOLYMODSYS_XQPOLYMULSYS_XQPOLYRNDSYS_XQPOLYSQRTSYS_XQPOLYSUBSYS_XQPOLYUMUSSYS_XQPOLYUPLSSYS_XQPOLYVEQSYS_XQPOLYVGESYS_XQPOLYVGTSYS_XQPOLYVLESYS_XQPOLYVLTSYS_XQPOLYVNESYS_XQREF2VALSYS_XQRENAMESYS_XQREPLACESYS_XQRESVURISYS_XQRNDHALF2EVNSYS_XQRSLVQNMSYS_XQRYENVPGETSYS_XQRYVARGETSYS_XQRYWRPSYS_XQSEQ2CONSYS_XQSEQ2CON4XCSYS_XQSEQDEEPEQSYS_XQSEQINSBSYS_XQSEQRMSYS_XQSEQRVSSYS_XQSEQSUBSYS_XQSEQTYPMATCHSYS_XQSTARTSWITHSYS_XQSTATBURISYS_XQSTR2CODEPSYS_XQSTRJOINSYS_XQSUBSTRAFTSYS_XQSUBSTRBEFSYS_XQTOKENIZESYS_XQTREATASSYS_XQXFORMSYS_XQ_ASQLCNVSYS_XQ_ATOMCNVCHKSYS_XQ_NRNGSYS_XQ_PKSQL2XMLSYS_XQ_UPKXML2SQLTTABLETABLESTABLESPACETABLESPACE_NOTABLE_STATSTABNOTANTANHTBL$OR$IDX$PART$NUMTEMPFILETEMPLATETEMPORARYTEMP_TABLETESTTHANTHETHENTHREADTHROUGHTIMETIMEOUTTIMESTIMESTAMPTIMEZONE_ABBRTIMEZONE_HOURTIMEZONE_MINUTETIMEZONE_OFFSETTIMEZONE_REGIONTIME_ZONETIV_GBTIV_SSFTOTOPLEVELTO_BINARY_DOUBLETO_BINARY_FLOATTO_BLOBTO_CHARTO_CLOBTO_DATETO_DSINTERVALTO_LOBTO_MULTI_BYTETO_NCHARTO_NCLOBTO_NUMBERTO_SINGLE_BYTETO_TIMETO_TIMESTAMPTO_TIMESTAMP_TZTO_TIME_TZTO_YMINTERVALTRACETRACINGTRACKINGTRAILINGTRANSACTIONTRANSFORM_DISTINCT_AGGTRANSITIONTRANSITIONALTRANSLATETREATTRIGGERTRIGGERSTRIMTRUETRUNCTRUNCATETRUSTEDTUNINGTXTYPETYPESTZ_OFFSETUUB2UBAUIDUNARCHIVEDUNBOUNDUNBOUNDEDUNDERUNDOUNDROPUNIFORMUNIONUNIQUEUNISTRUNLIMITEDUNLOCKUNNESTUNPACKEDUNPIVOTUNPROTECTEDUNQUIESCEUNRECOVERABLEUNRESTRICTEDUNTILUNUSABLEUNUSEDUPDATABLEUPDATEUPDATEDUPDATEXMLUPD_INDEXESUPD_JOININDEXUPGRADEUPPERUPSERTUROWIDUSAGEUSEUSERUSERENVUSERGROUPUSERSUSER_DEFINEDUSER_RECYCLEBINUSE_ANTIUSE_CONCATUSE_HASHUSE_HASH_AGGREGATIONUSE_INVISIBLE_INDEXESUSE_MERGEUSE_MERGE_CARTESIANUSE_NLUSE_NL_WITH_INDEXUSE_PRIVATE_OUTLINESUSE_SEMIUSE_STORED_OUTLINESUSE_TTT_FOR_GSETSUSE_WEAK_NAME_RESLUSINGVALIDATEVALIDATIONVALUEVALUESVARCHARVARCHAR2VARIANCEVARRAYVARRAYSVARYINGVAR_POPVAR_SAMPVECTOR_READVECTOR_READ_TRACEVERIFYVERSIONVERSIONINGVERSIONSVERSIONS_ENDSCNVERSIONS_ENDTIMEVERSIONS_OPERATIONVERSIONS_STARTSCNVERSIONS_STARTTIMEVERSIONS_XIDVIEWVIRTUALVISIBLEVOLUMEVSIZEWAITWALLETWELLFORMEDWHENWHENEVERWHEREWHITESPACEWIDTH_BUCKETWITHWITHINWITHOUTWORKWRAPPEDWRITEXIDXMLXMLATTRIBUTESXMLCASTXMLCDATAXMLCOLATTVALXMLCOMMENTXMLCONCATXMLDIFFXMLELEMENTXMLEXISTSXMLEXISTS2XMLFORESTXMLINDEX_REWRITEXMLINDEX_REWRITE_IN_SELECTXMLINDEX_SEL_IDX_TBLXMLISNODEXMLISVALIDXMLNAMESPACESXMLPARSEXMLPATCHXMLPIXMLQUERYXMLROOTXMLSCHEMAXMLSERIALIZEXMLTABLEXMLTOOBJECTXMLTRANSFORMXMLTRANSFORMBLOBXMLTYPEXML_DML_RWT_STMTXPATHTABLEXS_SYS_CONTEXTX_DYN_PRUNEYEARYESZONE[]^{|}
SQLServer
https://msdn.microsoft.com/zh-cn/library/ms189822
下表列出了 SQL Server 保留关键字。
add
EXTERNAL
PROCEDURE
ALL
FETCH
PUBLIC
ALTER
FILE
RAISERROR
And
FILLFACTOR
READ
ANY
FOR
READTEXT
As
FOREIGN
RECONFIGURE
ASC
FREETEXT
REFERENCES
AUTHORIZATION
FREETEXTTABLE
REPLICATION
BACKUP
from
RESTORE
BEGIN
FULL
RESTRICT
BETWEEN
FUNCTION
RETURN
BREAK
GOTO
REVERT
BROWSE
GRANT
REVOKE
BULK
GROUP
RIGHT
BY
HAVING
ROLLBACK
CASCADE
HOLDLOCK
ROWCOUNT
Case
IDENTITY
ROWGUIDCOL
CHECK
IDENTITY_INSERT
RULE
CHECKPOINT
IDENTITYCOL
SAVE
close
IF
SCHEMA
CLUSTERED
IN
SECURITYAUDIT
COALESCE
INDEX
SELECT
COLLATE
INNER
SEMANTICKEYPHRASETABLE
COLUMN
INSERT
SEMANTICSIMILARITYDETAILSTABLE
COMMIT
INTERSECT
SEMANTICSIMILARITYTABLE
COMPUTE
INTO
SESSION_USER
CONSTRAINT
is
SET
CONTAINS
JOIN
SETUSER
CONTAINSTABLE
KEY
SHUTDOWN
CONTINUE
KILL
SOME
CONVERT
LEFT
STATISTICS
CREATE
LIKE
SYSTEM_USER
CROSS
LINENO
TABLE
CURRENT
LOAD
TABLESAMPLE
CURRENT_DATE
MERGE
TEXTSIZE
CURRENT_TIME
NATIONAL
THEN
CURRENT_TIMESTAMP
NOCHECK
目标
CURRENT_USER
NONCLUSTERED
TOP
CURSOR
NOT
TRAN
DATABASE
NULL
TRANSACTION
DBCC
NULLIF
Trigger
DEALLOCATE
OF
TRUNCATE
DECLARE
OFF
TRY_CONVERT
DEFAULT
OFFSETS
TSEQUAL
delete
ON
UNION
DENY
OPEN
UNIQUE
DESC
OPENDATASOURCE
UNPIVOT
DISK
OPENQUERY
UPDATE
DISTINCT
OPENROWSET
UPDATETEXT
DISTRIBUTED
OPENXML
USE
DOUBLE
OPTION
USER
DROP
OR
VALUES
DUMP
ORDER
VARYING
Else
OUTER
View
END
OVER
WAITFOR
ERRLVL
PERCENT
WHEN
ESCAPE
PIVOT
WHERE
EXCEPT
PLAN
WHILE
EXEC
PRECISION
WITH
EXECUTE
PRIMARY
WITHIN GROUP
EXISTS
PRINT
WRITETEXT
EXIT
PROC
 


 此外,ISO 标准定义了保留关键字列表。 不要使用 ISO 保留关键字作为对象名和标识符。 ODBC 保留关键字列表(如下表所示)与 ISO 保留关键字列表相同。
注意

ISO 标准保留关键字有时可能比 SQL Server 限制更多,有时则更少。 例如,ISO 保留关键字列表包含 INT。 SQL Server 不必将此区分为保留关键字。
Transact-SQL 保留关键字可用作数据库或数据库对象(如表、列、视图等)的标识符或名称。 使用带引号的标识符或分隔标识符。 不限制将保留关键字用作变量和存储过程参数的名
ODBC 保留关键字
保留了下列关键字以用于 ODBC 函数调用。这些关键字根本不约束 SQL 语法;然而,为确保与支持核心 SQL 语法的驱动程序兼容,应用程序应避免使用这些关键字。
下面是当前的 ODBC 保留关键字列表。
ABSOLUTE
EXEC
OVERLAPS
ACTION
EXECUTE
PAD
ADA
EXISTS
PARTIAL
ADD
EXTERNAL
PASCAL
ALL
EXTRACT
POSITION
ALLOCATE
FALSE
PRECISION
ALTER
FETCH
PREPARE
AND
FIRST
PRESERVE
ANY
FLOAT
PRIMARY
ARE
FOR
PRIOR
AS
FOREIGN
PRIVILEGES
ASC
FORTRAN
PROCEDURE
ASSERTION
FOUND
PUBLIC
AT
FROM
READ
AUTHORIZATION
FULL
REAL
AVG
GET
REFERENCES
BEGIN
GLOBAL
RELATIVE
BETWEEN
GO
RESTRICT
BIT
GOTO
REVOKE
BIT_LENGTH
GRANT
RIGHT
BOTH
GROUP
ROLLBACK
BY
HAVING
ROWS
CASCADE
HOUR
SCHEMA
CASCADED
IDENTITY
SCROLL
CASE
IMMEDIATE
SECOND
CAST
IN
SECTION
CATALOG
INCLUDE
SELECT
CHAR
INDEX
SESSION
CHAR_LENGTH
INDICATOR
SESSION_USER
CHARACTER
INITIALLY
SET
CHARACTER_LENGTH
INNER
SIZE
CHECK
INPUT
SMALLINT
CLOSE
INSENSITIVE
SOME
COALESCE
INSERT
SPACE
COLLATE
INT
SQL
COLLATION
INTEGER
SQLCA
COLUMN
INTERSECT
SQLCODE
COMMIT
INTERVAL
SQLERROR
CONNECT
INTO
SQLSTATE
CONNECTION
IS
SQLWARNING
CONSTRAINT
ISOLATION
SUBSTRING
CONSTRAINTS
JOIN
SUM
CONTINUE
KEY
SYSTEM_USER
CONVERT
LANGUAGE
TABLE
CORRESPONDING
LAST
TEMPORARY
COUNT
LEADING
THEN
CREATE
LEFT
TIME
CROSS
LEVEL
TIMESTAMP
CURRENT
LIKE
TIMEZONE_HOUR
CURRENT_DATE
LOCAL
TIMEZONE_MINUTE
CURRENT_TIME
LOWER
TO
CURRENT_TIMESTAMP
MATCH
TRAILING
CURRENT_USER
MAX
TRANSACTION
CURSOR
MIN
TRANSLATE
DATE
MINUTE
TRANSLATION
DAY
MODULE
TRIM
DEALLOCATE
MONTH
TRUE
DEC
NAMES
UNION
DECIMAL
NATIONAL
UNIQUE
DECLARE
NATURAL
UNKNOWN
DEFAULT
NCHAR
UPDATE
DEFERRABLE
NEXT
UPPER
DEFERRED
NO
USAGE
DELETE
NONE
USER
DESC
NOT
USING
DESCRIBE
NULL
VALUE
DESCRIPTOR
NULLIF
VALUES
DIAGNOSTICS
NUMERIC
VARCHAR
DISCONNECT
OCTET_LENGTH
VARYING
DISTINCT
OF
VIEW
DOMAIN
ON
WHEN
DOUBLE
ONLY
WHENEVER
DROP
OPEN
WHERE
ELSE
OPTION
WITH
END
OR
WORK
END-EXEC
ORDER
WRITE
ESCAPE
OUTER
YEAR
EXCEPT
OUTPUT
ZONE
EXCEPTION
 
 

将来的关键字
下列关键字可能会在将来的 SQL Server 版本中保留使用,作为将来要实现的新功能。注意,不要使用这些关键字作为标识符。
ABSOLUTE
HOST
RELATIVE
ACTION
HOUR
RELEASE
ADMIN
IGNORE
RESULT
AFTER
IMMEDIATE
RETURNS
AGGREGATE
INDICATOR
ROLE
ALIAS
INITIALIZE
ROLLUP
ALLOCATE
INITIALLY
ROUTINE
ARE
INOUT
ROW
ARRAY
INPUT
ROWS
ASENSITIVE
INT
SAVEPOINT
ASSERTION
INTEGER
SCROLL
ASYMMETRIC
INTERSECTION
SCOPE
AT
INTERVAL
SEARCH
ATOMIC
ISOLATION
SECOND
BEFORE
ITERATE
SECTION
BINARY
LANGUAGE
SENSITIVE
BIT
LARGE
SEQUENCE
BLOB
LAST
SESSION
BOOLEAN
LATERAL
SETS
BOTH
LEADING
SIMILAR
BREADTH
LESS
SIZE
CALL
LEVEL
SMALLINT
CALLED
LIKE_REGEX
SPACE
CARDINALITY
LIMIT
SPECIFIC
CASCADED
LN
SPECIFICTYPE
CAST
LOCAL
SQL
CATALOG
LOCALTIME
SQLEXCEPTION
CHAR
LOCALTIMESTAMP
SQLSTATE
CHARACTER
LOCATOR
SQLWARNING
CLASS
MAP
START
CLOB
MATCH
STATE
COLLATION
MEMBER
STATEMENT
COLLECT
METHOD
STATIC
COMPLETION
MINUTE
STDDEV_POP
CONDITION
MOD
STDDEV_SAMP
CONNECT
MODIFIES
STRUCTURE
CONNECTION
MODIFY
SUBMULTISET
CONSTRAINTS
MODULE
SUBSTRING_REGEX
CONSTRUCTOR
MONTH
SYMMETRIC
CORR
MULTISET
SYSTEM
CORRESPONDING
NAMES
TEMPORARY
COVAR_POP
NATURAL
TERMINATE
COVAR_SAMP
NCHAR
THAN
CUBE
NCLOB
TIME
CUME_DIST
NEW
TIMESTAMP
CURRENT_CATALOG
NEXT
TIMEZONE_HOUR
CURRENT_DEFAULT_TRANSFORM_GROUP
NO
TIMEZONE_MINUTE
CURRENT_PATH
NONE
TRAILING
CURRENT_ROLE
NORMALIZE
TRANSLATE_REGEX
CURRENT_SCHEMA
NUMERIC
TRANSLATION
CURRENT_TRANSFORM_GROUP_FOR_TYPE
OBJECT
TREAT
CYCLE
OCCURRENCES_REGEX
TRUE
DATA
OLD
UESCAPE
DATE
ONLY
UNDER
DAY
OPERATION
UNKNOWN
DEC
ORDINALITY
UNNEST
DECIMAL
OUT
USAGE
DEFERRABLE
OVERLAY
USING
DEFERRED
OUTPUT
VALUE
DEPTH
PAD
VAR_POP
DEREF
PARAMETER
VAR_SAMP
DESCRIBE
PARAMETERS
VARCHAR
DESCRIPTOR
PARTIAL
VARIABLE
DESTROY
PARTITION
WHENEVER
DESTRUCTOR
PATH
WIDTH_BUCKET
DETERMINISTIC
POSTFIX
WITHOUT
DICTIONARY
PREFIX
WINDOW
DIAGNOSTICS
PREORDER
WITHIN
DISCONNECT
PREPARE
WORK
DOMAIN
PERCENT_RANK
WRITE
DYNAMIC
PERCENTILE_CONT
XMLAGG
EACH
PERCENTILE_DISC
XMLATTRIBUTES
ELEMENT
POSITION_REGEX
XMLBINARY
END-EXEC
PRESERVE
XMLCAST
EQUALS
PRIOR
XMLCOMMENT
EVERY
PRIVILEGES
XMLCONCAT
EXCEPTION
RANGE
XMLDOCUMENT
FALSE
READS
XMLELEMENT
FILTER
REAL
XMLEXISTS
FIRST
RECURSIVE
XMLFOREST
FLOAT
REF
XMLITERATE
FOUND
REFERENCING
XMLNAMESPACES
FREE
REGR_AVGX
XMLPARSE
FULLTEXTTABLE
REGR_AVGY
XMLPI
FUSION
REGR_COUNT
XMLQUERY
GENERAL
REGR_INTERCEPT
XMLSERIALIZE
GET
REGR_R2
XMLTABLE
GLOBAL
REGR_SLOPE
XMLTEXT
GO
REGR_SXX
XMLVALIDATE
GROUPING
REGR_SXY
YEAR
HOLD
REGR_SYY
ZONE

感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!