下方清單列出 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 |
