6.10.1 予約語の一覧
予約語は,SQL文で使用するキーワードとして登録されています。したがって,予約語を表や列の名称として指定できません。予約語と同じ文字列を名前に指定したい場合は,「6.10.2 名前が予約語と重複した場合の対応」を参照してください。
- メモ
-
HADBの予約語は,SQL92(ISO 9075−1992 Database Language SQL)で規定されている予約語に準拠しています。
HADBの予約語を次の表に示します。
頭文字 |
予約語 |
---|---|
A |
ABS,ABSOLUTE,ACCESS,ACTION,ADD,ADMIN,AFTER,AGGREGATE,AGGREGATES,ALIAS,ALL,ALLOCATE,ALTER,AND,ANDNOT,ANY,ARE,ARRAY,ARRAY_AGG,ARRAY_MAX_CARDINALITY,AS,ASC,ASENSITIVE,ASSERTION,ASSIGN,ASYMMETRIC,AT,ATOMIC,AUTHORIZATION,AVG |
B |
BEFORE,BEGIN,BEGIN_FRAME,BEGIN_PARTITION,BETWEEN,BIGINT,BINARY,BIT,BIT_AND_TEST,BIT_LENGTH,BLOB,BOOLEAN,BOTH,BREADTH,BY |
C |
CALL,CALLED,CARDINALITY,CASCADE,CASCADED,CASE,CAST,CATALOG,CEIL,CEILING,CHANGE,CHAR,CHAR_LENGTH,CHARACTER,CHARACTER_LENGTH,CHECK,CHUNK,CHUNKID,CLASS,CLASSIFIER,CLOB,CLOSE,CLUSTER,COALESCE,COLLATE,COLLATION,COLLECT,COLUMN,COLUMNS,COMMENT,COMMIT,COMPLETION,CONDITION,CONNECT,CONNECTION,CONSTRAINT,CONSTRAINTS,CONSTRUCTOR,CONTINUE,CONVERT,CORR,CORRESPONDING,COUNT,COUNT_FLOAT,COVAR_POP,COVAR_SAMP,CREATE,CROSS,CUBE,CUME_DIST,CURRENT,CURRENT_CATALOG,CURRENT_DATE,CURRENT_PATH,CURRENT_ROLE,CURRENT_ROW,CURRENT_SCHEMA,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURRENT_USER_IS_DBA,CURSOR,CYCLE |
D |
DATA,DATALINK,DATE,DAY,DAYS,DBA,DEALLOCATE,DEC,DECIMAL,DECLARE,DEFAULT,DEFERRABLE,DEFERRED,DEFINE,DELETE,DENSE_RANK,DEPTH,DEREF,DESC,DESCRIBE,DESCRIPTOR,DESTROY,DESTRUCTOR,DETERMINISTIC,DIAGNOSTICS,DICTIONARY,DIGITS,DISCONNECT,DISTINCT,DLNEWCOPY,DLPREVIOUSCOPY,DLURLCOMPLETE,DLURLCOMPLETEONLY,DLURLCOMPLETEWRITE,DLURLPATH,DLURLPATHONLY,DLURLPATHWRITE,DLURLSCHEME,DLURLSERVER,DLVALUE,DO,DOMAIN,DOUBLE,DROP,DYNAMIC |
E |
EACH,ELEMENT,ELSE,ELSEIF,END,END_FRAME,END_PARTITION,END-EXEC,EQUALS,ESCAPE,EVERY,EXCEPT,EXCEPTION,EXCLUSIVE,EXEC,EXECUTE,EXISTS,EXIT,EXP,EXTERNAL,EXTRACT |
F |
FALSE,FETCH,FILTER,FIRST,FIRST_VALUE,FIX,FLAT,FLOAT,FLOOR,FOR,FOREIGN,FOUND,FRAME_ROW,FREE,FROM,FULL,FUNCTION,FUSION |
G |
GENERAL,GET,GLOBAL,GO,GOTO,GRANT,GROUP,GROUPING,GROUPS |
H |
HANDLER,HASH,HAVING,HEX,HOLD,HOST,HOUR,HOURS |
I |
IDENTIFIED,IDENTITY,IF,IGNORE,IMMEDIATE,IMPORT,IN,INCREMENTAL,INDEX,INDICATOR,INITIAL,INITIALIZE,INITIALLY,INNER,INOUT,INPUT,INSENSITIVE,INSERT,INT,INTEGER,INTERSECT,INTERSECTION,INTERVAL,INTO,IS,ISOLATION,ITERATE |
J |
JAR,JOIN |
K |
KEY |
L |
LAG,LANGUAGE,LARGE,LAST,LAST_VALUE,LATERAL,LEAD,LEADING,LEAVE,LEFT,LENGTH,LESS,LEVEL,LIKE,LIKE_REGEX,LIMIT,LIST,LISTAGG,LN,LOCAL,LOCALTIME,LOCALTIMESTAMP,LOCATOR,LOCK,LONG,LOOP,LOWER |
M |
MAP,MATCH,MATCH_NUMBER,MATCH_RECOGNIZE,MAX,MAXIMAL,MCHAR,MEASURES,MEMBER,MERGE,METHOD,MICROSECOND,MICROSECONDS,MILLISECOND,MILLISECONDS,MIN,MINUTE,MINUTES,MOD,MODE,MODIFIES,MODIFY,MODULE,MONTH,MONTHS,MULTISET,MVARCHAR |
N |
NAMES,NANOSECOND,NANOSECONDS,NATIONAL,NATURAL,NCHAR,NCLOB,NESTING,NEW,NEXT,NO,NONE,NORMALIZE,NOT,NOWAIT,NTH_VALUE,NTILE,NULL,NULLIF,NUMERIC,NVARCHAR |
O |
OBJECT,OCCURRENCES_REGEX,OCTET_LENGTH,OF,OFF,OFFSET,OLD,ON,ONE,ONLY,OPEN,OPERATION,OPTIMIZE,OPTION,OR,ORDER,ORDINALITY,OUT,OUTER,OUTPUT,OVER,OVERLAPS,OVERLAY |
P |
PAD,PAGE,PARAMETER,PARAMETERS,PARTIAL,PARTITION,PARTITIONED,PATH,PATTERN,PCTFREE,PER,PERCENT,PERCENT_RANK,PERCENTILE_CONT,PERCENTILE_DISC,PERIOD,PICOSECOND,PICOSECONDS,PORTION,POSITION,POSITION_REGEX,POSTFIX,POWER,PRECISION,PREFIX,PREORDER,PREPARE,PRESERVE,PRIMARY,PRIOR,PRIVATE,PRIVILEGES,PROCEDURE,PROGRAM,PROTECTED,PUBLIC,PURGE |
R |
RANGE,RANK,READ,READS,REAL,RECOVERY,RECURSIVE,REDO,REF,REFERENCES,REFERENCING,REGR_AVGX,REGR_AVGY,REGR_COUNT,REGR_INTERCEPT,REGR_R2,REGR_SLOPE,REGR_SXX,REGR_SXY,REGR_SYY,RELATIVE,RELEASE,REPEAT,RESIGNAL,RESTRICT,RESULT,RETURN,RETURNS,REVOKE,RIGHT,ROLE,ROLLBACK,ROLLUP,ROUTINE,ROW,ROW_NUMBER,ROWID,ROWS |
S |
SAVEPOINT,SCHEMA,SCOPE,SCROLL,SEARCH,SECOND,SECONDS,SECTION,SEEK,SELECT,SENSITIVE,SEQUENCE,SESSION,SESSION_USER,SET,SETS,SHARE,SIGNAL,SIMILAR,SIZE,SKIP,SMALLFLT,SMALLINT,SOME,SPACE,SPECIFIC,SPECIFICTYPE,SQL,SQLCODE,SQLCODE_OF_LAST_CONDITION,SQLCOUNT,SQLERRM_OF_LAST_CONDITION,SQLERROR,SQLEXCEPTION,SQLSTATE,SQLWARNING,SQRT,START,STATE,STATEMENT,STATIC,STDDEV_POP,STDDEV_SAMP,STRUCTURE,SUBMULTISET,SUBSE,SUBSTR,SUBSTRING,SUBSTRING_REGEX,SUM,SUPPRESS,SYMMETRIC,SYSTEM,SYSTEM_TIME,SYSTEM_USER |
T |
TABLE,TABLESAMPLE,TEMPORARY,TERMINATE,TEST,THAN,THEN,TIME,TIMESTAMP,TIMESTAMP_FORMAT,TIMEZONE_HOUR,TIMEZONE_MINUTE,TO,TRAILING,TRANSACTION,TRANSLATE,TRANSLATE_REGEX,TRANSLATION,TREAT,TRIGGER,TRIM,TRIM_ARRAY,TRUE,TRUNCATE,TYPE |
U |
UESCAPE,UNDER,UNDO,UNION,UNIQUE,UNKNOWN,UNNEST,UNTIL,UPDATE,UPPER,USAGE,USER,USING |
V |
VALUE,VALUE_OF,VALUES,VAR_POP,VAR_SAMP,VARBINARY,VARCHAR,VARCHAR_FORMAT,VARIABLE,VARYING,VERSIONING,VIEW |
W |
WAIT,WHEN,WHENEVER,WHERE,WHILE,WIDTH_BUCKET,WINDOW,WITH,WITHIN,WITHOUT,WORK,WRITE |
X |
XLIKE,XML,XMLAGG,XMLATTRIBUTES,XMLBINARY,XMLCAST,XMLCOMMENT,XMLCONCAT,XMLDOCUMENT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLITERATE,XMLNAMESPACES,XMLPARSE,XMLPI,XMLQUERY,XMLSERIALIZE,XMLTABLE,XMLTEXT,XMLVALIDATE |
Y |
YEAR,YEARS |
Z |
ZONE |
- 注
-
-
下線の予約語は,SQL92で規定されている予約語です。
-
網掛けが付いている予約語(色が付いている予約語)は,「6.10.2 名前が予約語と重複した場合の対応」の「(2) 重複した予約語を削除する」の方法で削除できない予約語です。
-