保留字列表
- Last UpdatedSep 24, 2024
- 1 minute read
本节列出一些关键字，这些关键字不得用于 SQL Access 的“绑定列表”、“表模板”以及 ODBC 接口。
如果将某个保留关键字用作“绑定列表”或“表模板”中的“列名”，则 Log Viewer 会记录一条错误消息。错误的类型取决于所用 ODBC 驱动程序以及该关键字出现的位置。例如，最常见的错误之一是在“绑定列表”或“表模板”中将 DATE 与 TIME 用作“列名”。为避免此错误，请使用略有不同的名称，例如“aDATE”与“aTIME”。
保留关键字定义 InTouch SQL Access 所用的“结构化查询语言”（Structured Query Language，简称 SQL）。正在使用的特定 ODBC 驱动程序也会识别出这些关键字。如果无法正确解释 SQL 命令，则“SQL 访问管理器”会生成一条错误消息，这可以在 Log Viewer 中查看到。
下面按字母顺序的列表显示 SQL Access 与 ODBC 的保留关键字：
|
ABSOLUTE |
ADA |
添加 |
|
所有 |
ALLOCATE |
ALTER |
|
与 |
ANY |
ARE |
|
AS |
ASC |
ASSERTION |
|
AT |
AUTHORIZATION |
AVG |
|
BEGIN |
BETWEEN |
BIT |
|
BIT_LENGTH |
BY |
CASCADE |
|
CASCADED |
CASE |
CAST |
|
CATALOG |
CHAR |
CHAR_LENGTH |
|
CHARACTER |
CHARACTER_LENGTH |
CHECK |
|
CLOSE COALESCE |
COBOL |
COLLATE |
|
COLLATION |
COLUMN |
COMMIT |
|
CONNECT |
CONNECTION |
CONSTRAINT |
|
CONSTRAINTS |
CONTINUE |
CONVERT |
|
CORRESPONDING |
COUNT |
CREATE |
|
CURRENT |
CURRENT_DATE |
CURRENT_TIME |
|
CURRENT_TIMESTAMP |
CURSOR |
DATE |
|
DAY |
DEALLOCATE |
DEC |
|
DECIMAL |
DECLARE |
DEFERRABLE |
|
DEFERRED |
删除 |
DESC |
|
DESCRIBE |
DESCRIPTOR |
DIAGNOSTICS |
|
DICTIONARY |
DISCONNECT |
DISPLACEMENT |
|
DISTINCT |
DOMAIN |
DOUBLE |
|
DROP |
ELSE |
END |
|
ESCAPE |
EXCEPT |
EXCEPTION |
|
EXEC |
EXECUTE |
EXISTS |
|
EXTERNAL |
EXTRACT |
FALSE |
|
FETCH |
FIRST |
FLOAT |
|
FOR FOREIGN |
FORTRAN |
FOUND |
|
FROM FULL |
GET |
GLOBAL |
|
GO |
GOTO |
GRANT |
|
GROUP |
HAVING |
HOUR |
|
IDENTITY |
IGNORE |
IMMEDIATE |
|
IN |
INCLUDE |
INDEX |
|
INDICATOR |
INITIALLY |
INNER |
|
INPUT |
INSENSITIVE |
插入 |
|
INTEGER |
INTERSECT |
INTERVALL |
|
INTO |
IS |
ISOLATION |
|
JOIN |
KEY |
LANGUAGE |
|
LAST |
LEFT |
LEVEL |
|
LIKE |
LOCAL |
LOWER |
|
MATCH |
MAX |
MIN |
|
MINUTE |
MODULE |
MONTH |
|
MUMPS |
NAMES |
NATIONAL |
|
NCHAR |
NEXT |
NONE |
|
非 |
NULL |
NULLIF |
|
NUMERIC |
OCTET_LENGTH |
OF |
|
关闭 |
打开 |
ONLY |
|
OPEN |
OPRN |
OPTION |
|
或 |
ORDER |
OUTER |
|
输出 |
OVERLAPS |
PARTIAL |
|
PASCAL |
PLI |
POSITION |
|
PRECISION |
PREPARE |
PRESERVE |
|
PRIMARY |
PRIOR |
PRIVILEGES |
|
PROCEDURE |
PUBLIC |
RESTRICT |
|
REVOKE |
RIGHT |
ROLLBACK |
|
ROWS |
SCHEMA |
SCROLL |
|
SECOND |
SECTION |
选择 |
|
SEQUENCE |
设置 |
SIZE |
|
SMALLINT |
SOME |
SQL |
|
SQLCA |
SQLCODE |
SQLERROR |
|
SQLSTATE |
SQLWARNING |
SUBSTRING |
|
SUM |
系统 |
TABLE |
|
TEMPORARY |
THEN |
TIME |
|
TIMESTAMP |
TIMEZONE_HOUR |
TIMEZONE_MINU |
|
TO |
TRANSACTION |
TRANSLATE |
|
TRANSLATION |
TRUE |
UNION |
|
UNIQUE |
UNKNOWN |
UPDATE |
|
UPPER |
USAGE |
USING |
|
值 |
VALUES |
VARCHAR |
|
VARING |
VIEW |
WHEN |
|
WHENEVER |
WHERE |
WITH |
|
WORK |
YEAR |