1.10 予約語

ここでは,予約語について説明します。

予約語は,SQL文で使用するキーワードとして登録されています。したがって,予約語を表や列の名称として定義できません。なお,予約語をSQL文中に使用する必要がある場合,二重引用符(")で囲んでください。予約語を二重引用符(")で囲むと,一般の文字列と同じようにSQL文で使用できます。

XDBの予約語を次の表に示します。

表1-26 予約語

頭文字予約語
AABS,ABSOLUTE,ACCESS,ACTION,ADD,AFTER,ALIAS,ALL,ALLOCATE,ALTER,AND,ANDNOT,ANY,ARE,ARRAY,AS,ASC,ASSERTION,ASSIGN,AT,AUTHORIZATION,AVG
BBEFORE,BEGIN,BETWEEN,BINARY,BIT,BIT_AND_TEST,BIT_LENGTH,BLOB,BOOLEAN,BOTH,BREADTH,BY
CCALL,CASCADE,CASE,CAST,CATALOG,CHANGE,CHAR,CHAR_LENGTH,CHARACTER,CHARACTER_LENGTH,CHECK,CLOB,CLOSE,CLUSTER,COALESCE,COLLATE,COLLATION,COLUMN,COMMENT,COMMIT,CONDITION,CONNECT,CONNECTION,CONSTRAINT,CONSTRAINTS,CONSTRUCTOR,CONTINUE,CONVERT,CORRESPONDING,COUNT,COUNT_FLOAT,CREATE,CROSS,CUBE,CURRENT,CURRENT_DATE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR,CYCLE
DDATA,DATE,DAY,DAYS,DBA,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DELETE,DEPTH,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS,DIGITS,DISCONNECT,DISTINCT,DO,DOUBLE,DROP
EEACH,ELSE,ELSEIF,END,ESCAPE,EXCEPT,EXCEPTION,EXCLUSIVE,EXEC,EXECUTE,EXISTS,EXIT,EXTERNAL,EXTRACT
FFALSE,FETCH,FIRST,FIX,FLAT,FLOAT,FOR,FOREIGN,FOUND,FREE,FROM,FULL,FUNCTION
GGET,GLOBAL,GO,GOTO,GRANT,GROUP,GROUPING
HHANDLER,HASH,HAVING,HEX,HOUR,HOURS
IIDENTIFIED,IDENTITY,IF,IMMEDIATE,IN,INDEX,INDICATOR,INITIALLY,INNER,INOUT,INPUT,INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERVAL,INTO,IS,ISOLATION,ITERATE
JJOIN
KKEY
LLANGUAGE,LARGE,LAST,LEADING,LEAVE,LEFT,LENGTH,LEVEL,LIKE,LIMIT,LIST,LOCAL,LOCATOR,LOCK,LONG,LOOP,LOWER
MMATCH,MAX,MCHAR,MICROSECOND,MICROSECONDS,MIN,MINUTE,MINUTES,MOD,MODE,MODULE,MONTH,MONTHS,MVARCHAR
NNAMES,NATIONAL,NATURAL,NCHAR,NCLOB,NEW,NEXT,NO,NONE,NOT,NOWAIT,NULL,NULLIF,NUMERIC,NVARCHAR
OOBJECT,OCTET_LENGTH,OF,OFFSET,OLD,ON,ONLY,OPEN,OPTIMIZE,OPTION,OR,ORDER,OUT,OUTER,OUTPUT
PPAD,PAGE,PARTIAL,PARTITIONED,PCTFREE,POSITION,PRECISION,PREPARE,PRESERVE,PRIMARY,PRIOR,PRIVATE,PRIVILEGES,PROCEDURE,PROGRAM,PROTECTED,PUBLIC,PURGE
Q
RREAD,REAL,RECOVERY,RECURSIVE,REFERENCES,REFERENCING,RELATIVE,RELEASE,REPEAT,RESIGNAL,RESTRICT,RETURN,RETURNS,REVOKE,RIGHT,ROLLBACK,ROLLUP,ROUTINE,ROW,ROWID,ROWS
SSAVEPOINT,SCHEMA,SCROLL,SEARCH,SECOND,SECONDS,SECTION,SELECT,SENSITIVE,SEQUENCE,SESSION,SESSION_USER,SET,SHARE,SIGNAL,SIMILAR,SIZE,SMALLFLT,SMALLINT,SOME,SPACE,SQL,SQLCODE,SQLCODE_OF_LAST_CONDITION,SQLCOUNT,SQLERRM_OF_LAST_CONDITION,SQLERROR,SQLEXCEPTION,SQLSTATE,SQLWARNING,STRUCTURE,SUBSTR,SUBSTRING,SUM,SUPPRESS,SYSTEM_USER
TTABLE,TEMPORARY,TEST,THEN,TIME,TIMESTAMP,TIMESTAMP_FORMAT,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIGGER,TRIM,TRUE,TYPE
UUNDER,UNION,UNIQUE,UNKNOWN,UNTIL,UPDATE,UPPER,USAGE,USER,USING
VVALUE,VALUES,VARCHAR,VARCHAR_FORMAT,VARYING,VIEW
WWAIT,WHEN,WHENEVER,WHERE,WHILE,WITH,WITHOUT,WORK,WRITE
XXLIKE
YYEAR,YEARS
Z
(凡例)
-:該当しません。