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

野性酷女 2024-03-16 10:56 29阅读 0赞

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

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

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