ここでは,予約語について説明します。
予約語は,SQL文で使用するキーワードとして登録されています。したがって,予約語を表や列の名称として定義できません。なお,予約語をSQL文中に使用する必要がある場合,二重引用符(")で囲んでください。予約語を二重引用符(")で囲むと,一般の文字列と同じようにSQL文で使用できます。
XDBの予約語を次の表に示します。
表1-26 予約語
頭文字 | 予約語 |
---|---|
A | ABS,ABSOLUTE,ACCESS,ACTION,ADD,AFTER,ALIAS,ALL,ALLOCATE,ALTER,AND,ANDNOT,ANY,ARE,ARRAY,AS,ASC,ASSERTION,ASSIGN,AT,AUTHORIZATION,AVG |
B | BEFORE,BEGIN,BETWEEN,BINARY,BIT,BIT_AND_TEST,BIT_LENGTH,BLOB,BOOLEAN,BOTH,BREADTH,BY |
C | CALL,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 |
D | DATA,DATE,DAY,DAYS,DBA,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DELETE,DEPTH,DESC,DESCRIBE,DESCRIPTOR,DIAGNOSTICS,DIGITS,DISCONNECT,DISTINCT,DO,DOUBLE,DROP |
E | EACH,ELSE,ELSEIF,END,ESCAPE,EXCEPT,EXCEPTION,EXCLUSIVE,EXEC,EXECUTE,EXISTS,EXIT,EXTERNAL,EXTRACT |
F | FALSE,FETCH,FIRST,FIX,FLAT,FLOAT,FOR,FOREIGN,FOUND,FREE,FROM,FULL,FUNCTION |
G | GET,GLOBAL,GO,GOTO,GRANT,GROUP,GROUPING |
H | HANDLER,HASH,HAVING,HEX,HOUR,HOURS |
I | IDENTIFIED,IDENTITY,IF,IMMEDIATE,IN,INDEX,INDICATOR,INITIALLY,INNER,INOUT,INPUT,INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERVAL,INTO,IS,ISOLATION,ITERATE |
J | JOIN |
K | KEY |
L | LANGUAGE,LARGE,LAST,LEADING,LEAVE,LEFT,LENGTH,LEVEL,LIKE,LIMIT,LIST,LOCAL,LOCATOR,LOCK,LONG,LOOP,LOWER |
M | MATCH,MAX,MCHAR,MICROSECOND,MICROSECONDS,MIN,MINUTE,MINUTES,MOD,MODE,MODULE,MONTH,MONTHS,MVARCHAR |
N | NAMES,NATIONAL,NATURAL,NCHAR,NCLOB,NEW,NEXT,NO,NONE,NOT,NOWAIT,NULL,NULLIF,NUMERIC,NVARCHAR |
O | OBJECT,OCTET_LENGTH,OF,OFFSET,OLD,ON,ONLY,OPEN,OPTIMIZE,OPTION,OR,ORDER,OUT,OUTER,OUTPUT |
P | PAD,PAGE,PARTIAL,PARTITIONED,PCTFREE,POSITION,PRECISION,PREPARE,PRESERVE,PRIMARY,PRIOR,PRIVATE,PRIVILEGES,PROCEDURE,PROGRAM,PROTECTED,PUBLIC,PURGE |
Q | - |
R | READ,REAL,RECOVERY,RECURSIVE,REFERENCES,REFERENCING,RELATIVE,RELEASE,REPEAT,RESIGNAL,RESTRICT,RETURN,RETURNS,REVOKE,RIGHT,ROLLBACK,ROLLUP,ROUTINE,ROW,ROWID,ROWS |
S | SAVEPOINT,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 |
T | TABLE,TEMPORARY,TEST,THEN,TIME,TIMESTAMP,TIMESTAMP_FORMAT,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATION,TRIGGER,TRIM,TRUE,TYPE |
U | UNDER,UNION,UNIQUE,UNKNOWN,UNTIL,UPDATE,UPPER,USAGE,USER,USING |
V | VALUE,VALUES,VARCHAR,VARCHAR_FORMAT,VARYING,VIEW |
W | WAIT,WHEN,WHENEVER,WHERE,WHILE,WITH,WITHOUT,WORK,WRITE |
X | XLIKE |
Y | YEAR,YEARS |
Z | - |