自由手記

包含了 Microsoft Jet 數據庫引擎保留用於 SQL 語句所有保留單詞。列表中沒有全部採用大寫字母的單詞也是其他應用程序的保留字。所以，這些保留字的各個幫助主題提供一般性說明，而不只是著重說明 SQL 用法。

註釋 後面帶有星號 (*) 的保留字是為以後保留的，但當前在 Microsoft® Jet SQL 語句的上下文中沒有意義（例如，Level 和 TableID）。不加下劃線的保留字沒有鏈接的解釋。

A

ABSOLUTE ANY
ADD ARE
ADMINDB AS
全部 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 計數
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 Clause
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 最大
LEFT MEMO — 請參閱 LONGTEXT
Level* 最小
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
或 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 St​​Dev
SELECT StDevP
SELECTSCHEMA STRING — 請參閱 TEXT
SELECTSECURITY SUBSTRING
SET 合計
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