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)。未加下划线的字没有链接的解释。
ABSOLUTE | ANY |
ADD | ARE |
ADMINDB | AS |
ALL | ASC |
Alphanumeric — See TEXT | ASSERTION |
ALTER | AUTHORIZATION |
ALTER TABLE | AUTOINCREMENT — See COUNTER |
And | Avg |
AS |
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 |
DATABASE | DISALLOW |
DATE — See DATETIME | DISCONNECT |
DATETIME | DISTINCT |
DAY | DISTINCTROW |
DEC, DECIMAL | DOMAIN |
DECLARE | DOUBLE |
DELETE | DROP |
DESC |
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 |
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 |
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 |
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 |
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 |
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 |