Feeds:
文章
留言

Archive for 八月 24th, 2006

ACCESS 的 SQL 保留字

摘自 Microsoft Access 2006 線上說明


下列清單包含所有 Microsoft Jet 資料庫引擎保留的字詞,以用於 SQL 陳述式。列示在清單中的非大寫字母字詞也保留在其他應用程式中。因此,這些字詞個別的說明主題,提供非針對 SQL 用法的一般性描述。

附註  末端加上星號 (*) 的字詞已保留,但目前在 Microsoft® Jet SQL 陳述式中並沒有意義 (例如 LevelTableID)。無底線的字詞沒有連結的解釋。

A

ABSOLUTE ANY
ADD ARE
ADMINDB AS
ALL ASC
Alphanumeric — 參閱 TEXT ASSERTION
ALTER AUTHORIZATION
ALTER TABLE AUTOINCREMENT — h0 m,4 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
TINTINT 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

Read Full Post »