SQL 保留字

项目
04/04/2023

适用于：Access 2013、Office 2013

以下列表列出了 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