常用数据库保留字列表

本文详细列举了常见数据库系统的保留字,并讨论了在编程和设计时如何避免与这些保留字冲突,确保数据库操作的稳定性和安全性。同时,提到了在处理异常、描述符、授权、时区和OpenXML等特定数据库功能时需要注意的事项。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

开头字母公共OracleDB2SybaseSQLServerMysql
AADDACCESSALIASANYANYANALYZE
ALLANYALLOCATEASCASCASC
ALTERASCALLOW AUTHORIZATIONASENSITIVE
AND AUDITALTER   
AS   ANY   
  APPLICATION   
  ASSOCIATE   
  ASUTIME   
  AUDIT   
  AUTHORIZATION   
  AUX   
  AUXILIARY   
BBETWEENBYBEFOREBACKUP  BACKUPBEFORE
  BEGINBEGIN  BEGINBIGINT
  BINARYBIGINT  BREAKBINARY
  BUFFERPOOLBINARYBROWSEBLOB
  BY BULKBOTH
    BYBY
CCHECK  CHARCACHECALL  CASCADECALL
CREATE  CLUSTERCALLCASCADE  CASECASCADE
 COLUMNCALLEDCASE  CHECKPOINTCASE
 COMMENTCAPTURECAST  CLOSECHANGE
 COMPRESSCARDINALITYCHAR  CLUSTEREDCHAR
 CONNECTCASCADEDCHAR_CONVERT  COALESCECHARACTER
 CURRENT    CASECHARACTER  COLLATECOLLATE
  CASTCHECKPOINT  COLUMNCOLUMN
  CCSIDCLOSE  COMMITCONDITION
  CHARCOMMENT  COMPUTECONNECTION
  CHARACTERCOMMIT  CONSTRAINTCONSTRAINT
  CLOSECONNECT  CONTAINSCONTINUE
  CLUSTERCONSTRAINT  CONTAINSTABLECONVERT
  COLLECTIONCONTINUE  CONTINUECROSS
  COLLIDCONVERT  CONVERTCURRENT_DATE
  COLUMNCROSS  CROSSCURRENT_TIME
  COMMENTCURRENT  CURRENTCURRENT_TIMESTAMP
  COMMITCURSOR  CURRENT_DATECURRENT_USER
  CONCAT CURRENT_TIMECURSOR
  CONDITION CURRENT_TIMESTAMP 
  CONNECT CURRENT_USER 
  CONNECTION CURSOR 
  CONSTRAINT   
  CONTAINS   
  CONTINUE   
  COUNT   
  COUNT_BIG   
  CROSS   
  CURRENT   
  CURRENT_DATE   
  CURRENT_LC_CTYPE   
  CURRENT_PATH   
  CURRENT_SERVER   
  CURRENT_TIME   
  CURRENT_TIMESTAMP   
  CURRENT_TIMEZONE   
  CURRENT_USER   
  CURSOR   
  CYCLE   
DDEFAULT  DATEDATADATE  DATABASEDATABASE
DELETEDECIMALDATABASEDBSPACE  DBCCDATABASES
DISTINCTDESCDAYDEALLOCATE  DEALLOCATEDAY_HOUR
DROP DAYSDEC  DECLAREDAY_MICROSECOND
  DB2GENERALDECIMAL  DENYDAY_MINUTE
  DB2GENRLDECLARE  DESCDAY_SECOND
  DB2SQLDESC  DISKDEC
  DBINFODISABLE  DISTRIBUTEDDECIMAL
  DECLAREDO  DOUBLEDECLARE
  DEFAULTSDOUBLE  DUMMYDELAYED
  DEFINITIONDYNAMIC  DUMPDESC
  DESCRIPTOR  DESCRIBE
  DETERMINISTIC  DETERMINISTIC
  DISALLOW  DISTINCTROW
  DISCONNECT  DIV
  DO  DOUBLE
  DOUBLE  DUAL
  DSNHATTR   
  DSSIZE   
  DYNAMIC   
EELSEEXCLUSIVEEACHELSEIF                ENDEACH
 EXISTSEDITPROCENABLEERRLVLELSEIF
 ELSEIFENCRYPTEDESCAPEENCLOSED
  ENCODINGEND  EXCEPTESCAPED
  ENDENDIF EXECEXISTS
  END-EXECESCAPEEXECUTEEXIT
  END-EXEC1EXCEPTION  EXISTSEXPLAIN
  ERASEEXEC EXIT 
  ESCAPE   
  EXCEPT   
  EXCEPTION   
  EXCLUDING   
  EXECUTE   
  EXISTS   
  EXIT   
  EXTERNAL   
F FILEFENCEDEXECUTE  FETCHFETCH
 FLOATFETCHEXISTINGFILEFLOAT
 FORFIELDPROCEXISTS FILLFACTORFLOAT4
 FROMFILEEXTERNLOGINFORFLOAT8
  FINALFOREIGN   FOREIGNFOR
  FORFORWARD   FREETEXTFORCE
  FOREIGNFROM   FREETEXTTABLEFOREIGN
  FREEFULL   FROMFROM
  FROMFULLFULLTEXT
  FULL FUNCTIONFALSE
  FUNCTION   
GGROUP GENERALGOTO   GOTOGOTO
GRANT GENERATED   
  GET   
  GLOBAL   
  GO   
  GOTO   
  GRAPHIC   
HHAVING   HANDLERHOLDLOCK   HOLDLOCKHIGH_PRIORITY
  HOLD  HOUR_MICROSECOND
  HOUR  HOUR_MINUTE
  HOURS  HOUR_SECOND
IINIDENTIFIEDIDENTITYIDENTIFIED   IDENTITYIF
INDEXIMMEDIATEIFIF   IDENTITY_INSERTIGNORE
INSERTINCREMENTIMMEDIATEINNER   IDENTITYCOLINFILE
INTOINITIALINCLUDINGINOUT   IFINNER
IS INTEGERINCREMENTINSENSITIVE   INNERINOUT
 INTERSECTINDICATORINSTALL   INTERSECTINSENSITIVE
  INHERITINSTEAD   INT
  INNERINT    INT1
  INOUTINTEGER   INT2
  INSENSITIVEINTEGRATED    INT3
  INTEGRITYIQ    INT4
  ISOBIDISOLATION    INT8
  ISOLATION  INTEGER
  ITERATE       INTERVAL
    ITERATE
J  JARJOINJOINJOIN
  JAVA   
  JOIN   
K    KEY       KEY  KEYKEY
    KILLKEYS
     KILL
LLIKELEVELLABELLEFT   LEFTLABEL
 LOCKLANGUAGELOCK   LINENOLEADING
 LONG   LC_CTYPELOGIN   LOADLEAVE
 LEAVELONG   LEFT
    LEFT LIMIT
  LINKTYPE LINEAR
  LOCAL  LINES
  LOCALE  LOAD
  LOCATOR  LOCALTIME
  LOCATORS  LOCALTIMESTAMP
  LOCK  LOCK
  LOCKMAX  LONG
  LOCKSIZE  LONGBLOB
  LONG  LONGTEXT
  LOOP  LOOP
    LOW_PRIORITY
M MAXEXTENTSMAXVALUEMATCH    MATCH
 MINUSMICROSECONDMEMBERSHIP    MEDIUMBLOB
 MLSLABELMICROSECONDSMESSAGE    MEDIUMINT
 MODEMINUTEMODE    MEDIUMTEXT
 MODIFYMINUTESMODIFY   MIDDLEINT
  MINVALUE MINUTE_MICROSECOND
  MODE  MINUTE_SECOND
  MODIFIES  MOD
  MONTH  MODIFIES
  MONTHS   
NNOTNOAUDITNEWNATURAL   NATIONALNATURAL
NULLNOCOMPRESSNEW_TABLENEW   NOCHECKNO_WRITE_TO_BINLOG
 NOWAITNONO   NONCLUSTEREDNUMERIC
 NUMBERNOCACHENOTIFY   NULLIF 
  NOCYCLENUMERIC    
  NODENAME  
  NODENUMBER  
  NOMAXVALUE        
  NOMINVALUE   
  NOORDER   
  NULLS   
  NUMPARTS   
OOPTIONOFOBIDOF   OFOPTIMIZE
ONOFFLINEOFOFF   OFFOPTIONALLY
ORONLINEOLDOPEN   OFFSETSOUT
ORDER OLD_TABLEOPTIONS   OPENOUTER
  OPENOTHERS   OPENDATASOURCEOUTFILE
  OPTIMIZATIONOUT   OPENQUERY 
  OPTIMIZEOUTER   OPENROWSET 
  OUT OPENXML 
  OUTER OUTER 
  OVERRIDINGOVER 
P PCTFREEPACKAGEPASSTHROUGH   PERCENTPRECISION
 PRIORPARAMETERPRECISION   PLANPRIMARY
 PRIVILEGESPARTPREPARE   PRECISIONPROCEDURE
 PUBLICPARTITIONPRIMARY   PRIMARYPURGE
  PATHPRINT   PRINT 
  PIECESIZEPRIVILEGES   PROC 
  PLANPROC   PROCEDURE 
  POSITIONPROCEDURE   PUBLIC 
  PRECISIONPUBLICATION  
  PREPARE   
  PRIMARY   
  PRIQTY   
  PRIVILEGES   
  PROCEDURE   
  PROGRAM   
  PSID   
Q  QUERYNO   
RREVOKERAWREADRAISERROR   RAISERRORRAID0
 RENAMEREADSREADTEXT   READRANGE
 RESOURCERECOVERYREAL   READTEXTREAD
 ROWREFERENCESREFERENCE   RECONFIGUREREADS
 ROWIDREFERENCINGREFERENCES   REFERENCESREAL
 ROWNUMRELEASERELEASE   REPLICATIONREFERENCES
 ROWSRENAMEREMOTE   RESTOREREGEXP
 REPEATREMOVE   RESTRICTRELEASE
  RESETRENAME   RETURNRENAME
  RESIGNALRESOURCE   RIGHTREPEAT
  RESTARTRESTORE   ROLLBACKREPLACE
  RESTRICTRESTRICT   ROWCOUNTREQUIRE
  RESULTRETURN   ROWGUIDCOLRESTRICT
  RESULT_SET_LOCATORRIGHT   RULERETURN
  RETURNROLLBACK  RIGHT
  RETURNS RLIKE
  RIGHT   
  ROLLBACK        
  ROUTINE   
  ROW   
  ROWS   
  RRN   
  RUN   
SSELECTSESSIONSAVEPOINTSAVE   SAVESCHEMA
SETSHARESCHEMASAVEPOINT   SCHEMASCHEMAS
 SIZESCRATCHPADSCHEDULE   SESSION_USERSECOND_MICROSECOND
 SMALLINTSECONDSCROLL   SETUSERSENSITIVE
 STARTSECONDSSESSION   SHUTDOWNSEPARATOR
 SUCCESSFULSECQTYSETUSER   SOMESHOW
 SYNONYMSECURITYSHARE   STATISTICSSMALLINT
 SYSDATESENSITIVESMALLINT   SYSTEM_USERSPATIAL
  SIGNALSOME    SPECIFIC
  SIMPLESQLCODE    SQL
  SOMESQLSTATE    SQL_BIG_RESULT
  SOURCESTART    SQL_CALC_FOUND_ROWS
  SPECIFICSTOP    SQL_SMALL_RESULT
  SQLSUBTRANS    SQLEXCEPTION
  SQLIDSYNCHRONIZE    SQLSTATE
  STANDARDSYNTAX_ERROR    SQLWARNING
  START SSL
  STATIC  STARTING
  STAY  STRAIGHT_JOIN
  STOGROUP   
  STORES   
  STYLE   
  SUBPAGES        
  SUBSTRING   
  SYNONYM   
  SYSFUN   
  SYSIBM   
  SYSPROC   
  SYSTEM   
TTABLE TABLESPACETEMPORARY   TEXTSIZETERMINATED
THEN TRANSACTIONTIME   TOPTINYBLOB
TO TRIMTIMESTAMP   TRANTINYINT
TRIGGER TYPETINYINT   TRANSACTIONTINYTEXT
   TOP   TRUNCATETRAILING
   TRAN   TSEQUALTRUE
   TRUNCATE    
   TSEQUAL     
UUNIONUIDUNDOUNKNOWN   UPDATETEXTUNDO
UNIQUEUSERUNTILUNSIGNED   USEUNLOCK
UPDATE USAGEUSER   USERUNSIGNED
  USERUSING    USAGE
  USING  USE
     USING
     UTC_DATE
     UTC_TIME
          UTC_TIMESTAMP
VVALUESVALIDATEVALIDPROCVALIDATE   VARYINGVARBINARY
 VARCHARVARIABLEVARBINARY VIEWVARCHAR
 VARCHAR2VARIANTVARCHAR   VARCHARACTER
 VIEWVCATVARIABLE    VARYING
 VIEWVARYING     
  VOLUMESVIEW  
WWHEREWHENEVERWHENWHEN   WAITFORWHEN
WITH WHILEWHILE   WHENWHILE
  WLMWORK   WHILEWRITE
  WRITEWRITETEXT  WRITETEXT 
X     X509
     XOR
Y  YEAR  YEAR_MONTH
  YEARS   
Z     ZEROFILL
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值