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 |