以下列表列出了 Microsoft Access 数据库引擎用于 SQL 语句的所有保留字。 列表中未完全采用大写形式的保留字也是其他应用程序的保留字。 因此,这些保留字的相关帮助主题提供常规说明,而不只是针对 SQL。
注意: 后跟星号 (*) 的词也是保留字,但当前在 Microsoft Access SQL 语句(例如 Level 和 TableID)的上下文中没有任何意义。 无下划线的词没有链接说明。
A
ABSOLUTE |
ANY |
ADD |
ARE |
ADMINDB |
AS |
ALL |
ASC |
Alphanumeric -请参阅 TEXT |
ASSERTION |
ALTER |
AUTHORIZATION |
ALTER TABLE |
AUTOINCREMENT - 请参阅 COUNTER |
And |
Avg |
AS |
B-C
BEGIN |
COLLATION |
Between |
COLUMN |
BINARY |
COMMIT |
BIT |
COMP、COMPRESSION |
BIT_LENGTH |
CONNECT |
BOOLEAN - 请参阅 BIT |
CONNECTION |
BOTH |
CONSTRAINT、CONSTRAINTS |
BY |
CONTAINER |
BYTE |
CONTAINS |
CASCADE |
CONVERT |
CATALOG |
Count |
CHAR、CHARACTER - 请参阅 TEXT |
COUNTER |
CHAR_LENGTH |
CREATE |
CHARACTER_LENGTH |
CURRENCY |
CHECK |
CURRENT_DATE |
CLOSE |
CURRENT_TIME |
CLUSTERED |
CURRENT_TIMESTAMP |
COALESCE |
CURRENT_USER |
COLLATE |
CURSOR |
D
DATABASE |
DISALLOW |
DATE - 请参阅 DATETIME |
DISCONNECT |
DATETIME |
DISTINCT |
DAY |
DISTINCTROW |
DEC、DECIMAL |
DOMAIN |
DECLARE |
DOUBLE |
DELETE |
DROP |
DESC |
E-H
Eqv |
FOREIGN |
EXCLUSIVECONNECT |
FROM |
EXEC、EXECUTE |
FROM 子句 |
EXISTS |
GENERAL - 请参阅 LONGBINARY |
EXTRACT |
GRANT |
FALSE |
GROUP |
FETCH |
GUID |
FIRST |
HAVING |
FLOAT、FLOAT8 - 请参阅 DOUBLE |
HOUR |
FLOAT4 - 请参阅 SINGLE |
I
IDENTITY |
INPUT |
IEEEDOUBLE - 请参阅 DOUBLE |
INSENSITIVE |
IEEESINGLE - 请参阅 SINGLE |
INSERT |
IGNORE |
INSERT INTO |
IMAGE |
INT、INTEGER、INTEGER4 - 请参阅 LONG |
Imp |
INTEGER1 - 请参阅 BYTE |
In |
INTEGER2 - 请参阅 SHORT |
IN |
INTERVAL |
INDEX |
INTO |
INDEXCREATEDB |
Is |
INNER |
ISOLATION |
J-M
JOIN |
LONGTEXT |
KEY |
LOWER |
LANGUAGE |
MATCH |
LAST |
Max |
LEFT |
MEMO - 请参阅 LONGTEXT |
Level* |
Min |
Like |
MINUTE |
LOGICAL、LOGICAL1 - 请参阅 BIT |
Mod |
LONG |
MONEY - 请参阅 CURRENCY |
LONGBINARY |
MONTH |
LONGCHAR |
N-P
NATIONAL |
Outer* |
NCHAR |
OUTPUT |
NONCLUSTERED |
OWNERACCESS |
Not |
PAD |
NTEXT |
PARAMETERS |
NULL |
PARTIAL |
NUMBER - 请参阅 DOUBLE |
PASSWORD |
NUMERIC - 请参阅 DECIMAL |
PERCENT |
NVARCHAR |
PIVOT |
OCTET_LENGTH |
POSITION |
OLEOBJECT - 请参阅 LONGBINARY |
PRECISION |
ON |
PREPARE |
OPEN |
PRIMARY |
OPTION |
PRIVILEGES |
Or |
PROC、PROCEDURE |
ORDER |
PUBLIC |
Q-S
REAL - 请参阅 SINGLE |
SMALLDATETIME |
REFERENCES |
SMALLINT - 请参阅 SHORT |
RESTRICT |
SMALLMONEY |
REVOKE |
SOME |
RIGHT |
SPACE |
ROLLBACK |
SQL |
SCHEMA |
SQLCODE、SQLERROR、SQLSTATE |
SECOND |
StDev |
SELECT |
StDevP |
SELECTSCHEMA |
STRING - 请参阅 TEXT |
SELECTSECURITY |
SUBSTRING |
SET |
Sum |
SHORT |
SYSNAME |
SINGLE |
SYSTEM_USER |
SIZE |
T-Z
TABLE |
UPDATEOWNER |
TableID* |
UPDATESECURITY |
TEMPORARY |
UPPER |
TEXT |
USAGE |
TIME - 请参阅 DATETIME |
USER |
TIMESTAMP |
USING |
TIMEZONE_HOUR |
VALUE |
TIMEZONE_MINUTE |
VALUES |
TINYINT |
Var |
TO |
VARBINARY - 请参阅 BINARY |
TOP |
VARCHAR - 请参阅 TEXT |
TRAILING |
VarP |
TRANSACTION |
VARYING |
TRANSFORM |
VIEW |
TRANSLATE |
WHEN |
TRANSLATION |
WHENEVER |
TRIM |
WHERE |
TRUE |
WITH |
UNION |
WORK |
UNIQUE |
Xor |
UNIQUEIDENTIFIER |
YEAR |
UNKNOWN |
YESNO - 请参阅 BIT |
UPDATE |
ZONE |
UPDATEIDENTITY |