Sign in with Microsoft
Sign in or create an account.

A B C D E F G H I J K L M  

N O P Q R S T U V W X Y Z

下方清單列出 Microsoft Access 資料庫引擎保留給 SQL 陳述式使用的所有字詞。 清單中並非全部使用大寫字母的字詞是由其他應用程式所保留。 因此,這些字詞專屬的 [說明] 主題提供的一般說明並不是以 SQL 使用為出發點。

附註: 後方加上星號 (*) 的字詞為目前在 Microsoft Access SQL 陳述式 (例如 LevelTableID) 中沒有任何意義的保留字。 未加上底下的字詞則沒有提供說明連結。

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



Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

How satisfied are you with the translation quality?
What affected your experience?

Thank you for your feedback!

×