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

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

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

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

9de7bb31d0644e7393039222babfed10

欢迎收藏。

informix

AAO ABS ABSOLUTE ACCELERATE ACCESS ACCESS_METHOD ACCOUNT ACOS ACOSH ACTIVE ADD ADDRESS ADD_MONTHS ADMIN AFTER AGGREGATE ALIGNMENT ALL ALL_ROWS ALLOCATE ALTER AND ANSI ANY APPEND AQT ARRAY AS ASC ASCII ASIN ASINH ASYNC AT ATAN ATAN2 ATANH ATTACH ATTRIBUTES AUDIT AUTHENTICATION AUTHID AUTHORIZATION AUTHORIZED AUTO AUTOFREE AUTOLOCATE AUTO_READAHEAD AUTO_REPREPARE AUTO_STAT_MODE AVG AVOID_EXECUTE AVOID_FACT AVOID_FULL AVOID_HASH AVOID_INDEX AVOID_INDEX_SJ AVOID_MULTI_INDEX AVOID_NL AVOID_STAR_JOIN

BARGROUP BASED BEFORE BEGIN BETWEEN BIGINT BIGSERIAL BINARY BITAND BITANDNOT BITNOT BITOR BITXOR BLOB BLOBDIR BOOLEAN BOTH BOUND_IMPL_PDQ BSON BUCKETS BUFFERED BUILTIN BY BYTE

CACHE CALL CANNOTHASH CARDINALITY CASCADE CASE CAST CEIL CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHARINDEX CHECK CHR CLASS CLASS_ORIGIN CLEANUP CLIENT CLOB CLOBDIR CLOSE CLUSTER CLUSTER_TXN_SCOPE COBOL CODESET COLLATION COLLECTION COLUMN COLUMNS COMMIT COMMITTED COMMUTATOR COMPONENT COMPONENTS COMPRESSED CONCAT CONCURRENT CONNECT CONNECTION CONNECTION_NAME CONNECT_BY_ISCYCLE CONNECT_BY_ISLEAF CONNECT_BY_ROOT CONST CONSTRAINT CONSTRAINTS CONSTRUCTOR CONTEXT CONTINUE COPY COS COSH COSTFUNC COUNT CRCOLS CREATE CROSS CUME_DIST CURRENT CURRENT_ROLE CURRENT_USER CURRVAL CURSOR CYCLE

DATA DATABASE DATAFILES DATASKIP DATE DATETIME DAY DBA DBDATE DBINFO DBPASSWORD DBSA DBSERVERNAME DBSECADM DBSSO DEALLOCATE DEBUG DEBUGMODE DEBUG_ENV DEC DECIMAL DECLARE DECODE DECRYPT_BINARY DECRYPT_CHAR DEC_T DEFAULT DEFAULTESCCHAR DEFAULT_ROLE DEFAULT_USER DEFERRED DEFERRED_PREPARE DEFINE DEGREES DELAY DELETE DELETING DELIMITED DELIMITER DELUXE DENSERANK DENSE_RANK DESC DESCRIBE DESCRIPTOR DETACH DIAGNOSTICS DIRECTIVES DIRTY DISABLE DISABLED DISCARD DISCONNECT DISK DISTINCT DISTRIBUTEBINARY DISTRIBUTESREFERENCES DISTRIBUTIONS DOCUMENT DOMAIN DONOTDISTRIBUTE DORMANT DOUBLE DROP DTIME_T

EACH ELIF ELSE ENABLE ENABLED ENCRYPT_AES ENCRYPT_TDES ENCRYPTION END ENUM ENVIRONMENT ERKEY ERROR ESCAPE EXCEPT EXCEPTION EXCLUSIVE EXEC EXECUTE EXECUTEANYWHERE EXEMPTION EXISTS EXIT EXP EXPLAIN EXPLICIT EXPRESS EXPRESSION EXTDIRECTIVES EXTEND EXTENT EXTERNAL EXTYPEID EXTYPELENGTH EXTYPENAME EXTYPEOWNERLENGTH EXTYPEOWNERNAME

FACT FALLBACK FALSE FAR FETCH FILE FILETOBLOB FILETOCLOB FILLFACTOR FILTERING FINAL FIRST FIRST_ROWS FIRST_VALUE FIXCHAR FIXED FLOAT FLOOR FLUSH FOLLOWING FOR FORCE FORCED FORCE_DDL_EXEC FOREACH FOREIGN FORMAT FORMAT_UNITS FORTRAN FOUND FRACTION FRAGMENT FRAGMENTS FREE FROM FULL FUNCTION

G GB GENBSON GENERAL GET GETHINT GIB GLOBAL GO GOTO GRANT GREATERTHAN GREATERTHANOREQUAL GRID GRID_NODE_SKIP GROUP

HANDLESNULLS HASH HAVING HDR HDR_TXN_SCOPE HEX HIGH HINT HOLD HOME HOUR

IDATA IDSLBACREADARRAY IDSLBACREADSET IDSLBACREADTREE IDSLBACRULES IDSLBACWRITEARRAY IDSLBACWRITESET IDSLBACWRITETREE IDSSECURITYLABEL IF IFX_* ILENGTH IMMEDIATE IMPLICIT IMPLICIT_PDQ IN INACTIVE INCREMENT INDEX INDEXES INDEX_ALL INDEX_SJ INDICATOR INFORMIX INFORMIXCONRETRY INFORMIXCONTIME INIT INITCAP INLINE INNER INOUT INSENSITIVE INSERT INSERTING INSTEAD INSTR INT INT8 INTEG INTEGER INTERNAL INTERNALLENGTH INTERSECT INTERVAL INTO INTRVL_T IS ISCANONICAL ISOLATION ITEM ITERATOR ITYPE

JAVA JOIN JSON

KB KEEP KEY KIB

LABEL LABELEQ LABELGE LABELGLB LABELGT LABELLE LABELLT LABELLUB LABELTOSTRING LAG LANGUAGE LAST LAST_DAY LAST_VALUE LATERAL LEAD LEADING LEFT LEN LENGTH LESSTHAN LESSTHANOREQUAL LET LEVEL LIKE LIMIT LIST LISTING LOAD LOCAL LOCATOR LOCK LOCKS LOCOPY LOC_T LOG LOG10 LOGN LONG LOOP LOTOFILE LOW LOWER LPAD LTRIM LVARCHAR

M MATCHED MATCHES MAX MAXERRORS MAXLEN MAXVALUE MB MDY MEDIAN MEDIUM MEMORY MEMORY_RESIDENT MERGE MESSAGE_LENGTH MESSAGE_TEXT MIB MIN MINUS MINUTE MINVALUE MOD MODE MODERATE MODIFY MODULE MONEY MONTH MONTHS_BETWEEN MORE MULTISET MULTI_INDEX

NAME NCHAR NEAR_SYNC NEGATOR NEW NEXT NEXT_DAY NEXTVAL NLSCASE NO NOCACHE NOCYCLE NOMAXVALUE NOMIGRATE NOMINVALUE NONE NON_RESIDENT NON_DIM NOORDER NORMAL NOT NOTEMPLATEARG NOTEQUAL| NOVALIDATE NTILE NULL NULLABLE NULLIF NULLS NUMBER NUMERIC NUMROWS NUMTODSINTERVAL NUMTOYMINTERVAL NVARCHAR NVL

OCTET_LENGTH OF OFF OLD ON ONLINE ONLY OPAQUE OPCLASS OPEN OPTCOMPIND OPTIMIZATION OPTION OR ORDER ORDERED OUT OUTER OUTPUT OVER OVERRIDE

PAGE PARALLELIZABLE PARAMETER PARTITION PASCAL PASSEDBYVALUE PASSWORD PDQPRIORITY PERCALL_COST PERCENT_RANK PIPE PLI PLOAD POLICY POW POWER PRECEDING PRECISION PREPARE PREVIOUS PRIMARY PRIOR PRIVATE PRIVILEGES PROBE PROCEDURE PROPERTIES PUBLIC PUT

QUARTER

RADIANS RAISE RANGE RANK RATIOTOREPORT RATIO_TO_REPORT RAW READ REAL RECORDEND REFERENCES REFERENCING REGISTER REJECTFILE RELATIVE RELEASE REMAINDER RENAME REOPTIMIZATION REPEATABLE REPLACE REPLICATION RESOLUTION RESOURCE RESTART RESTRICT RESUME RETAIN RETAINUPDATELOCKS RETURN RETURNED_SQLSTATE RETURNING RETURNS REUSE REVERSE REVOKE RIGHT ROBIN ROLE ROLLBACK ROLLFORWARD ROLLING ROOT ROUND ROUTINE ROW ROWID ROWIDS ROWNUMBER ROWS ROW_COUNT ROW_NUMBER RPAD RTRIM RULE

SAMEAS SAMPLES SAMPLING SAVE SAVEPOINT SCHEMA SCALE SCROLL SECLABEL_BY_COMP SECLABEL_BY_NAME SECLABEL_TO_CHAR SECOND SECONDARY SECURED SECURITY SECTION SELCONST SELECT SELECTING SELECT_GRID SELECT_GRID_ALL SELFUNC SELFUNCARGS SENSITIVE SEQUENCE SERIAL SERIAL8 SERIALIZABLE SERVER SERVER_NAME SERVERUUID SESSION SET SETSESSIONAUTH SHARE SHORT SIBLINGS SIGNED SIN SITENAME SIZE SKIP SMALLFLOAT SMALLINT SOME SOURCEID SOURCETYPE SPACE SPECIFIC SQL SQLCODE SQLCONTEXT SQLERROR SQLSTATE SQLWARNING SQRT STABILITY STACK STANDARD START STAR_JOIN STATCHANGE STATEMENT STATIC STATISTICS STATLEVEL STATUS STDEV STEP STOP STORAGE STORE STRATEGIES STRING STRINGTOLABEL STRUCT STYLE SUBCLASS_ORIGIN SUBSTR SUBSTRING SUBSTRING_INDEX SUM SUPPORT SYNC SYNONYM SYS*

T TABLE TABLES TAN TASK TB TEMP TEMPLATE TEST TEXT THEN TIB TIME TO TODAY TO_CHAR TO_DATE TO_DSINTERVAL TO_NUMBER TO_YMINTERVAL TRACE TRAILING TRANSACTION TRANSITION TREE TRIGGER TRIGGERS TRIM TRUE TRUNC TRUNCATE TRUSTED TYPE TYPEDEF TYPEID TYPENAME TYPEOF

UID UNBOUNDED UNCOMMITTED UNDER UNION UNIQUE UNIQUECHECK UNITS UNKNOWN UNLOAD UNLOCK UNSIGNED UPDATE UPDATING UPON UPPER USAGE USE USELASTCOMMITTED USER USE_DWA USE_HASH USE_NL USING USTLOW_SAMPLE

VALUE VALUES VAR VARCHAR VARIABLE VARIANCE VARIANT VARYING VERCOLS VIEW VIOLATIONS VOID VOLATILE

WAIT WARNING WEEKDAY WHEN WHENEVER WHERE WHILE WITH WITHOUT WORK WRITE WRITEDOWN WRITEUP

XADATASOURCE XID XLOAD XUNLOAD

YEAR