 | 虫垂 A. 名簿（に載せる）／表（にあげる）s of Keywords |  |
| 一時期／支部 17. HyperSQL 経由で ODBC |  | 虫垂 B. HyperSQL Database とじ込み／提出するs and 回復 |
|
このページはEtoJ逐語翻訳フィルタによって翻訳生成されました。 |
| | 虫垂 A. 名簿（に載せる）／表（にあげる）s of Keywords | |
| 一時期／支部 17. HyperSQL 経由で ODBC | | 虫垂 B. HyperSQL Database とじ込み／提出するs and 回復 |
（米）棚上げする／（英）提議する of Contents
によれば the SQL 基準, the SQL Language reserved keywords cannot be used as identifiers (指名するs of database 反対するs such as columns and （米）棚上げする／（英）提議するs) without 引用するing.
HyperSQL has two 方式s of 操作／手術, which are selected with the
SET DATABASE SQL NAMES { TRUE | FALSE } to 許す or
disallow the keywords as identifiers. The default 方式 is FALSE and 許すs
the use of most keywords as identifiers. Even in this 方式, keywords
cannot be used as USER or ROLE identifiers. When the 方式 is TRUE, 非，不，無 of
the keywords 名簿（に載せる）／表（にあげる）d below can be used as unquoted identifiers.
All keywords can be used with 二塁打 引用するs as identifiers. For example
CREATE TABLE "ALL" ("AND" INT, "WHEN" INT)
SELECT "AND" FROM "ALL" WHERE "WHEN" = 2022
ABS • ABSENT • ACOS • ALL • ALLOCATE • ALTER • AND • ANY
• ANY_VALUE • ARE • ARRAY • ARRAY_AGG • ARRAY_MAX_CARDINALITY • AS •
ASENSITIVE • ASIN • ASYMMETRIC • AT • ATAN • ATOMIC • AUTHORIZATION •
AVG
BEGIN • BEGIN_FRAME • BEGIN_PARTITION • BETWEEN • BIGINT
• BINARY • BIT_LENGTH • BLOB • BOOLEAN • BOTH • BY
CALL • CALLED • CARDINALITY • CASCADED • CASE • CAST •
CEIL • CEILING • CHAR • CHARACTER • CHARACTER_LENGTH • CHAR_LENGTH • CHECK
• CLOB • CLOSE • COALESCE • COLLATE • COLLECT • COLUMN • COMMIT •
COMPARABLE • CONDIITON • CONNECT • CONSTRAINT • CONTAINS • CONVERT • CORR
• CORRESPONDING • COS • COSH • COUNT • COVAR_POP • COVAR_SAMP • CREATE •
CROSS • CUBE • CUME_DIST • CURRENT • CURRENT_CATALOG • CURRENT_DATE •
CURRENT_DEFAULT_TRANSFORM_GROUP • CURRENT_PATH • CURRENT_ROLE •
CURRENT_ROW • CURRENT_SCHEMA • CURRENT_TIME • CURRENT_TIMESTAMP •
CURRENT_TRANSFORM_GROUP_FOR_TYPE • CURRENT_USER • CURSOR •
CYCLE
DATE • DAY • DEALLOCATE • DEC • DECIMAL • DECLARE •
DEFAULT • DELETE • DENSE_RANK • DEREF • DESCRIBE • DETERMINISTIC •
DISCONNECT • DISTINCT • DO • DOUBLE • DROP • DYNAMIC
EACH • ELEMENT • ELSE • ELSEIF • EMPTY • END • END_EXEC
• END_FRAME • END_PARTITION • EQUALS • ESCAPE • EVERY • EXCEPT • EXEC •
EXECUTE • EXISTS • EXIT • EXP • EXTERNAL • EXTRACT
FALSE • FETCH • FILTER • FIRST_VALUE • FLOAT • FLOOR •
FOR • FOREIGN • FRAME_ROW • FREE • FROM • FULL • FUNCTION •
FUSION
GET • GLOBAL • GRANT • GROUP • GROUPING •
GROUPS
HANDLER • HAVING • HOLD • HOUR
IDENTITY • IF • IMPORT • IN • INDICATOR • INITIAL •
INNER • INOUT • INSENSITIVE • INSERT • INT • INTEGER • INTERSECT •
INTERSECTION • INTERVAL • INTO • IS • ITERATE
JOIN • JSON • JSON_ARRAY • JSON_ARRAYAGG • JSON_EXISTS •
JSON_OBJECT • JSON_OBJECTAGG • JSON_QUERY • JSON_TABLE •
JSON_VALUE
LAG • LANGUAGE • LARGE • LAST_VALUE • LATERAL • LEAD •
LEADING • LEAST • LEAVE • LEFT • LIKE • LIKE_REGX • LISTAGG • LN • LOCAL •
LOCALTIME • LOCALTIMESTAMP • LOG • LOG10 • LOOP • LOWER • LPAD •
LTRIM
MATCH • MAX • MAX_CARDINALITY • MEMBER • MERGE • METHOD
• MIN • MINUTE • MOD • MODIFIES • MODULE • MONTH •
MULTISET
NATIONAL • NATURAL • NCHAR • NCLOB • NEW • NO • NONE •
NORMALIZE • NOT • NTH_VALUE • NTILE • NULL • NULLIF •
NUMERIC
OCCURRENCES_REGEX • OCTET_LENGTH • OF • OFFSET • OLD •
OMIT • ON • ONLY • OPEN • OR • ORDER • OUT • OUTER • OVER • OVERLAPS •
OVERLAY
PARAMETER • PARTITION • PERCENTILE_CONT •
PERCENTILE_DISC • PERCENT_RANK • PERIOD • POSITION • POSITION_REGEX •
POWER • PRECEDES • PRECISION • PREPARE • PRIMARY •
PROCEDURE
RANGE • RANK • READS • REAL • RECURSIVE • REF •
REFERENCES • REFERENCING • REGR_AVGX • REGR_AVGY • REGR_COUNT •
REGR_INTERCEPT • REGR_R2 • REGR_SLOPE • REGR_SXX • REGR_SXY • REGR_SYY •
RELEASE • REPEAT • RESIGNAL • RESULT • RETURN • RETURNS • REVOKE • RIGHT •
ROLLBACK • ROLLUP • ROW • ROWS • ROW_NUMBER • RPAD •
RTRIM
SAVEPOINT • SCOPE • SCROLL • SEARCH • SECOND • SELECT •
SENSITIVE • SESSION_USER • SET • SIGNAL • SIMILAR • SIN • SINH • SMALLINT
• SOME • SPECIFIC • SPECIFICTYPE • SQL • SQLEXCEPTION • SQLSTATE •
SQLWARNING • SQRT • STACKED • （米ソ間の）戦略兵器削減交渉 • STATIC • STDDEV_POP • STDDEV_SAMP •
SUBMULTISET • SUBSTRING • SUBSTRING_REGEX • SUCCEEDS • SUM • SYMMETRIC •
SYSTEM • SYSTEM_TIME • SYSTEM_USER
TABLE • TABLESAMPLE • TAN • TANH • THEN • TIME •
TIMESTAMP • TIMEZONE_HOUR • TIMEZONE_MINUTE • TO • TRAILING • TRANSLATE •
TRANSLATE_REGEX • TRANSLATION • TREAT • TRIGGER • TRIM • TRIM_ARRAY • TRUE
• TRUNCATE
UESCAPE • UNDO • UNION • UNIQUE • UNKNOWN • UNNEST •
UNTIL • UPDATE • UPPER • USER • USING
VALUE • VALUES • VALUE_OF • VARBINARY • VARCHAR •
VARYING • VAR_POP • VAR_SAMP • VERSIONING
WHEN • WHENEVER • WHERE • WHILE • WIDTH_BUCKET • WINDOW
• WITH • WITHIN • WITHOUT
YEAR
When the default SET DATABASE SQL NAMES FALSE
方式 is used, only a subset of SQL 基準 keywords cannot be used as
HyperSQL identifiers. The keywords are as follows:
ALL • AND • ANY • ARRAY • AS • AT
BETWEEN • BOTH • BY
CALL • CASE • CAST • COALESCE • CONVERT • CORRESPONDING
• COUNT • CREATE • CROSS • CUBE
DEFAULT • DISTINCT • DO • DROP
ELSE • EVERY • EXCEPT • EXISTS
FETCH • FOR • FROM • FULL
GRANT • GROUP • GROUPING
HAVING
IN • INNER • INTERSECT • INTO • IS
JOIN
LEADING • LEFT • LIKE
MAX • MIN
NATURAL • NOT • NULLIF
ON • OR • ORDER • OUTER
PRIMARY
REFERENCES • RIGHT • ROLLUP
SELECT • SET • SOME • STDDEV_POP • STDDEV_SAMP •
SUM
TABLE • THEN • TO • TRAILING •
TRIGGER
UNION • UNIQUE • USING
VALUES • VAR_POP • VAR_SAMP
WHEN • WHERE • WITH
HyperSQL supports SQL 基準 機能（する）／行事s that are called without
parentheses. These 機能（する）／行事s 含む CURRENT_DATE,
LOCALTIMESTAMP, TIMEZONE_HOUR,
USER, etc. When the default SET DATABASE SQL
NAMES FALSE 方式 is used, keywords that are 指名するs of SQL
機能（する）／行事s can be used as column 指名するs without 二塁打 引用するs in CREATE
TABLE 声明s . But when the identifier is a column 指名する and is
言及／関連d in SELECT or other 声明s, the keywords must be 二塁打
引用するd. さもなければ the result of the SQL 機能（する）／行事 is returned instead of
the column value.
HyperSQL also supports 非，不，無-基準 機能（する）／行事s
SYSTIMESTAMP, CURDATE,
CURTIME, TODAY,
SYSDATE and NOW which can be called
with or without parentheses ( e.g. NOW() or
NOW ). These 指名するs can be used as column 指名するs, but the
指名するs must be 二塁打 引用するd in SELECT and other 声明s.
$Revision: 6787 $
| | |
|
| 一時期／支部 17. HyperSQL 経由で ODBC | | 虫垂 B. HyperSQL Database とじ込み／提出するs and 回復 |