SQL 保留字
优质
小牛编辑
118浏览
2023-12-01
SQL 保留字
下表包括了所有 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 |