更专业的选择
首页 > 介绍 > 帮助

表结构设计时应该避免使用的关键字

2016-04-08 10:42:09 阅读:loading...


MySQL保留关键字
ADDALLALTER
ANALYZEANDAS
ASCASENSITIVEBEFORE
BETWEENBIGINTBINARY
BLOBBOTHBY
CALLCASCADECASE
CHANGECHARCHARACTER
CHECKCOLLATECOLUMN
CONDITIONCONNECTIONCONSTRAINT
CONTINUECONVERTCREATE
CROSSCURRENT_DATECURRENT_TIME
CURRENT_TIMESTAMPCURRENT_USERCURSOR
DATABASEDATABASESDAY_HOUR
DAY_MICROSECONDDAY_MINUTEDAY_SECOND
DECDECIMALDECLARE
DEFAULTDELAYEDDELETE
DESCDESCRIBEDETERMINISTIC
DISTINCTDISTINCTROWDIV
DOUBLEDROPDUAL
EACHELSEELSEIF
ENCLOSEDESCAPEDEXISTS
EXITEXPLAINFALSE
FETCHFLOATFLOAT4
FLOAT8FORFORCE
FOREIGNFROMFULLTEXT
GOTOGRANTGROUP
HAVINGHIGH_PRIORITYHOUR_MICROSECOND
HOUR_MINUTEHOUR_SECONDIF
IGNOREININDEX
INFILEINNERINOUT
INSENSITIVEINSERTINT
INT1INT2INT3
INT4INT8INTEGER
INTERVALINTOIS
ITERATEJOINKEY
KEYSKILLLABEL
LEADINGLEAVELEFT
LIKELIMITLINEAR
LINESLOADLOCALTIME
LOCALTIMESTAMPLOCKLONG
LONGBLOBLONGTEXTLOOP
LOW_PRIORITYMATCHMEDIUMBLOB
MEDIUMINTMEDIUMTEXTMIDDLEINT
MINUTE_MICROSECONDMINUTE_SECONDMOD
MODIFIESNATURALNOT
NO_WRITE_TO_BINLOGNULLNUMERIC
ONOPTIMIZEOPTION
OPTIONALLYORORDER
OUTOUTEROUTFILE
PRECISIONPRIMARYPROCEDURE
PURGERAID0RANGE
READREADSREAL
REFERENCESREGEXPRELEASE
RENAMEREPEATREPLACE
REQUIRERESTRICTRETURN
REVOKERIGHTRLIKE
SCHEMASCHEMASSECOND_MICROSECOND
SELECTSENSITIVESEPARATOR
SETSHOWSMALLINT
SPATIALSPECIFICSQL
SQLEXCEPTIONSQLSTATESQLWARNING
SQL_BIG_RESULTSQL_CALC_FOUND_ROWSSQL_SMALL_RESULT
SSLSTARTINGSTRAIGHT_JOIN
TABLETERMINATEDTHEN
TINYBLOBTINYINTTINYTEXT
TOTRAILINGTRIGGER
TRUEUNDOUNION
UNIQUEUNLOCKUNSIGNED
UPDATEUSAGEUSE
USINGUTC_DATEUTC_TIME
UTC_TIMESTAMPVALUESVARBINARY
VARCHARVARCHARACTERVARYING
WHENWHEREWHILE
WITHWRITEX509
XORYEAR_MONTHZEROFILL



SQL Server保留关键字
ADDEXCEPTPERCENT
ALLEXECPLAN
ALTEREXECUTEPRECISION
ANDEXISTSPRIMARY
ANYEXITPRINT
ASFETCHPROC
ASCFILEPROCEDURE
AUTHORIZATIONFILLFACTORPUBLIC
BACKUPFORRAISERROR
BEGINFOREIGNREAD
BETWEENFREETEXTREADTEXT
BREAKFREETEXTTABLERECONFIGURE
BROWSEFROMREFERENCES
BULKFULLREPLICATION
BYFUNCTIONRESTORE
CASCADEGOTORESTRICT
CASEGRANTRETURN
CHECKGROUPREVOKE
CHECKPOINTHAVINGRIGHT
CLOSEHOLDLOCKROLLBACK
CLUSTEREDIDENTITYROWCOUNT
COALESCEIDENTITY_INSERTROWGUIDCOL
COLLATEIDENTITYCOLRULE
COLUMNIFSAVE
COMMITINSCHEMA
COMPUTEINDEXSELECT
CONSTRAINTINNERSESSION_USER
CONTAINSINSERTSET
CONTAINSTABLEINTERSECTSETUSER
CONTINUEINTOSHUTDOWN
CONVERTISSOME
CREATEJOINSTATISTICS
CROSSKEYSYSTEM_USER
CURRENTKILLTABLE
CURRENT_DATELEFTTEXTSIZE
CURRENT_TIMELIKETHEN
CURRENT_TIMESTAMPLINENOTO
CURRENT_USERLOADTOP
CURSORNATIONALTRAN
DATABASENOCHECKTRANSACTION
DBCCNONCLUSTEREDTRIGGER
DEALLOCATENOTTRUNCATE
DECLARENULLTSEQUAL
DEFAULTNULLIFUNION
DELETEOFUNIQUE
DENYOFFUPDATE
DESCOFFSETSUPDATETEXT
DISKONUSE
DISTINCTOPENUSER
DISTRIBUTEDOPENDATASOURCEVALUES
DOUBLEOPENQUERYVARYING
DROPOPENROWSETVIEW
DUMMYOPENXMLWAITFOR
DUMPOPTIONWHEN
ELSEORWHERE
ENDORDERWHILE
ERRLVLOUTERWITH
ESCAPEOVERWRITETEXT



Oracle保留关键字
ALLALTERAND
ANYASASC
ATBEGINBETWEEN
BYCASECHECK
CLUSTERSCLUSTERCOLAUTH
COLUMNSCOMPRESSCONNECT
CRASHCREATECURSOR
DECLAREDEFAULTDESC
DISTINCTDROPELSE
ENDEXCEPTIONEXCLUSIVE
FETCHFORFROM
FUNCTIONGOTOGRANT
GROUPHAVINGIDENTIFIED
IFININDEX
INDEXESINSERTINTERSECT
INTOISLIKE
LOCKMINUSMODE
NOCOMPRESSNOTNOWAIT
NULLOFON
OPTIONORORDER
OVERLAPSPROCEDUREPUBLIC
RESOURCEREVOKESELECT
SHARESIZESQL
STARTSUBTYPETABAUTH
TABLETHENTO
TYPEUNIONUNIQUE
UPDATEVALUESVIEW
VIEWSWHENWHERE
WITH


标签:数据库
上一页 1 下一页

评论

微信