SQL 保留字

<< 单击这里显示内容目录 >> 导航: Microsoft Jet SQL 参考 > 简介:

SQL 保留字

此页没有内容条目

内容

SQL 保留字

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 Jet 数据库引擎保留的用于 SQL 语句的字。列表中的字，若不是全部大写，也被其它应用程序所保留。因此，对于这些字的各个帮助主题只提供了通常的描述，并未着重 SQL的用法。

注意跟着一星号 * 的词是被保留的，但是当前在 Microsoft® Jet SQL 语句的范畴内并没有意义（例如，Level 和 TableID）。未加下划线的字没有链接的解释。

A

ABSOLUTE	ANY
ADD	ARE
ADMINDB	AS
ALL	ASC
Alphanumeric — See TEXT	ASSERTION
ALTER	AUTHORIZATION
ALTER TABLE	AUTOINCREMENT — See COUNTER
And	Avg
AS

B-C

BEGIN	COLLATION
Between	COLUMN
BINARY	COMMIT
BIT	COMP, COMPRESSION
BIT_LENGTH	CONNECT
BOOLEAN — See BIT	CONNECTION
BOTH	CONSTRAINT, CONSTRAINTS
BY	CONTAINER
BYTE	CONTAINS
CASCADE	CONVERT
CATALOG	Count
CHAR, CHARACTER — See 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 — See 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 — See LONGBINARY
EXTRACT	GRANT
FALSE	GROUP
FETCH	GUID
FIRST	HAVING
FLOAT，FLOAT8 — 参阅 DOUBLE	HOUR
FLOAT4 — See SINGLE

I

IDENTITY	INPUT
IEEEDOUBLE — See DOUBLE	INSENSITIVE
IEEESINGLE — See 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 — See DOUBLE	PASSWORD
NUMERIC — See DECIMAL	PERCENT
NVARCHAR	PIVOT
OCTET_LENGTH	POSITION
OLEOBJECT — See LONGBINARY	PRECISION
ON	PREPARE
OPEN	PRIMARY
OPTION	PRIVILEGES
Or	PROC, PROCEDURE
ORDER	PUBLIC

Q-S

REAL — See SINGLE	SMALLDATETIME
REFERENCES	SMALLINT — See SHORT
RESTRICT	SMALLMONEY
REVOKE	SOME
RIGHT	SPACE
ROLLBACK	SQL
SCHEMA	SQLCODE, SQLERROR, SQLSTATE
SECOND	StDev
SELECT	StDevP
SELECTSCHEMA	STRING — See TEXT
SELECTSECURITY	SUBSTRING
SET	Sum
SHORT	SYSNAME
SINGLE	SYSTEM_USER
SIZE

T-Z

TABLE	UPDATEOWNER
TableID*	UPDATESECURITY
TEMPORARY	UPPER
TEXT	USAGE
TIME — See 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 — See BIT
UPDATE	ZONE
UPDATEIDENTITY

索引页专业培训与服务: Access中级培训 | Access高级培训 | Access顶级培训 | 软件定制开发 | 通用开发平台 | Office插件 © by Office中国