数据库关键字整理之——DB2数据库

关键字是指在数据库中有意义的字，通常是数据库内部使用， 不能用于命名用户的数据对象。 有的数据库还会详细划分，例如分为关键字，候选字，甚至更详细的分类。分类的标准例如有的是绝对不可以使用，有的通过一定手段例如添加双引号可以使用。

我们为了方便统一称之为关键字，通常用户编写的对象中使用关键字会造成错误或不确定的影响，为了避免这个问题，用户应该避免使用数据库的关键字(含保留字或其他保留别名等)。

这个系列主要整理了各大数据库的关键字，可以用于建库，建表，写存储过程，函数等场景避免冲突。最后会有个脚本工具用来检查是否使用关键字。

9de7bb31d0644e7393039222babfed10

欢迎收藏。

DB2

ABS ACTIVATE ADD AFTER ALIAS ALL ALLOCATE ALLOW ALTER AND ANY ARE ARRAY AS ASENSITIVE ASSOCIATE ASUTIME ASYMMETRIC AT ATOMIC ATTRIBUTES AUDIT AUTHORIZATION AUX AUXILIARY AVG

BEFORE BEGIN BETWEEN BIGINT BINARY BLOB BOOLEAN BOTH BUFFERPOOL BY

CACHE CALL CALLED CAPTURE CARDINALITY CASCADED CASE CAST CCSID CEIL CEILING CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHECK CLOB CLONE CLOSE CLUSTER COALESCE COLLATE COLLECT COLLECTION COLLID COLUMN COMMENT COMMIT CONCAT CONDITION CONNECT CONNECTION CONSTRAINT CONTAINS CONTINUE CONVERT CORR CORRESPONDING COUNT COUNT_BIG COVAR_POP COVAR_SAMP CREATE CROSS CUBE CUME_DIST CURRENT CURRENT_DATE CURRENT_DEFAULT_TRANSFORM_GROUP CURRENT_LC_CTYPE CURRENT_PATH CURRENT_ROLE CURRENT_SCHEMA CURRENT_SERVER CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TIMEZONE CURRENT_TRANSFORM_GROUP_FOR_TYPE CURRENT_USER CURSOR CYCLE

DATA DATABASE DATAPARTITIONNAME DATAPARTITIONNUM DATE DAY DAYS DB2GENERAL DB2GENRL DB2SQL DBINFO DBPARTITIONNAME DBPARTITIONNUM DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFAULTS DEFINITION DELETE DENSE_RANK DENSERANK DEREF DESCRIBE DESCRIPTOR DETERMINISTIC DIAGNOSTICS DISABLE DISALLOW DISCONNECT DISTINCT DO DOCUMENT DOUBLE DROP DSSIZE DYNAMIC

EACH EDITPROC ELEMENT ELSE ELSEIF ENABLE ENCODING ENCRYPTION END END-EXEC ENDING ERASE ESCAPE EVERY EXCEPT EXCEPTION EXCLUDING EXCLUSIVE EXEC EXECUTE EXISTS EXIT EXP EXPLAIN EXTENDED EXTERNAL EXTRACT

FALSE FENCED FETCH FIELDPROC FILE FILTER FINAL FIRST FLOAT FLOOR FOR FOREIGN FREE FROM FULL FUNCTION FUSION

GENERAL GENERATED GET GLOBAL GO GOTO GRANT GRAPHIC GROUP GROUPING

HANDLER HASH HASHED_VALUE HAVING HINT HOLD HOUR HOURS

IDENTITY IF IMMEDIATE IMPORT IN INCLUDING INCLUSIVE INCREMENT INDEX INDICATOR INDICATORS INF INFINITY INHERIT INNER INOUT INSENSITIVE INSERT INT INTEGER INTEGRITY INTERSECT INTERSECTION INTERVAL INTO IS ISNULL ISOBID ISOLATION ITERATE

JAR JAVA JOIN

KEEP KEY

LABEL LANGUAGE LARGE LAST3 LATERAL LC_CTYPE LEADING LEAVE LEFT LIKE LIMIT LINKTYPE LN LOCAL LOCALDATE LOCALE LOCALTIME LOCALTIMESTAMP LOCATOR LOCATORS LOCK LOCKMAX LOCKSIZE LONG LOOP LOWER

MAINTAINED MATCH MATERIALIZED MAX MAXVALUE MEMBER MERGE METHOD MICROSECOND MICROSECONDS MIN MINUTE MINUTES MINVALUE MOD MODE MODIFIES MODULE MONTH MONTHS MULTISET

NAN NATIONAL NATURAL NCHAR NCLOB NEW NEW_TABLE NEXTVAL NO NOCACHE NOCYCLE NODENAME NODENUMBER NOMAXVALUE NOMINVALUE NONE NOORDER NORMALIZE NORMALIZED NOT NOTNULL NULL NULLIF NULLS NUMERIC NUMPARTS

OBID OCTET_LENGTH OF OFF OFFSET OLD OLD_TABLE ON ONLY OPEN OPTIMIZATION OPTIMIZE OPTION OR ORDER OUT OUTER OVER OVERLAPS OVERLAY OVERRIDING

PACKAGE PADDED PAGESIZE PARAMETER PART PARTITION PARTITIONED PARTITIONING PARTITIONS PASSWORD PATH PERCENT PERCENT_RANK PERCENTILE_CONT PERCENTILE_DISC PIECESIZE PLAN POSITION POWER PRECISION PREPARE PREVVAL PRIMARY PRIQTY PRIVILEGES PROCEDURE PROGRAM PSID PUBLIC

QUERY QUERYNO

RANGE RANK READ READS REAL RECOVERY RECURSIVE REF REFERENCES REFERENCING REFRESH REGR_AVGX REGR_AVGY REGR_COUNT REGR_INTERCEPT REGR_R2 REGR_SLOPE REGR_SXX REGR_SXY REGR_SYY RELEASE RENAME REPEAT RESET RESIGNAL RESTART RESTRICT RESULT RESULT_SET_LOCATOR RETURN RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUND_CEILING ROUND_DOWN ROUND_FLOOR ROUND_HALF_DOWN ROUND_HALF_EVEN ROUND_HALF_UP ROUND_UP ROUTINE ROW ROW_NUMBER ROWNUMBER ROWS ROWSET RRN RUN

SAVEPOINT SCHEMA SCOPE SCRATCHPAD SCROLL SEARCH SECOND SECONDS SECQTY SECURITY SELECT SENSITIVE SEQUENCE SESSION SESSION_USER SET SIGNAL SIMILAR SIMPLE SMALLINT SNAN SOME SOURCE SPECIFIC SPECIFICTYPE SQL SQLEXCEPTION SQLID SQLSTATE SQLWARNING SQRT STACKED STANDARD START STARTING STATEMENT STATIC STATMENT STAY STDDEV_POP STDDEV_SAMP STOGROUP STORES STYLE SUBMULTISET SUBSTRING SUM SUMMARY SYMMETRIC SYNONYM SYSFUN SYSIBM SYSPROC SYSTEM SYSTEM_USER

TABLE TABLESAMPLE TABLESPACE THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TRAILING TRANSACTION TRANSLATE TRANSLATION TREAT TRIGGER TRIM TRUE TRUNCATE TYPE

UESCAPE UNDO UNION UNIQUE UNKNOWN UNNEST UNTIL UPDATE UPPER USAGE USER USING

VALIDPROC VALUE VALUES VAR_POP VAR_SAMP VARBINARY VARCHAR VARIABLE VARIANT VARYING VCAT VERSION VIEW VOLATILE VOLUMES

WHEN WHENEVER WHERE WHILE WIDTH_BUCKET WINDOW WITH WITHIN WITHOUT WLM WRITE

XMLELEMENT XMLEXISTS XMLNAMESPACES

YEAR YEARS