Následující seznam obsahuje všechna slova vyhrazená pro databázový stroj Microsoft Access pro použití v příkazech jazyka SQL. Slova v seznamu, která nejsou uvedená celá velkými písmeny, jsou vyhrazená také jinými aplikacemi. Jednotlivá témata nápovědy pro tato slova pak poskytují obecné popisy, které se nezaměřují na použití v SQL.
Poznámka
Slova s hvězdičkou (*) na konci jsou vyhrazená, momentálně ale nemají žádný význam v kontextu příkazu jazyka SQL v Microsoft Accessu (například Level a TableID). Slova, která nejsou podtržená, nemají připojené vysvětlivky.
| ABSOLUTE | ANY |
|---|---|
| ADD | ARE |
| ADMINDB | AS |
| ALL | ASC |
| Alphanumeric – viz TEXT | ASSERTION |
| ALTER | AUTHORIZATION |
| ALTER TABLE | AUTOINCREMENT – viz COUNTER |
| And | Avg |
| AS |
| BEGIN | COLLATION |
|---|---|
| Between | COLUMN |
| BINARY | COMMIT |
| BIT | COMP, COMPRESSION |
| BIT_LENGTH | CONNECT |
| BOOLEAN – viz BIT | CONNECTION |
| BOTH | CONSTRAINT, CONSTRAINTS |
| BY | CONTAINER |
| BYTE | CONTAINS |
| CASCADE | CONVERT |
| CATALOG | Count |
| CHAR, CHARACTER – viz 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 – viz DATETIME | DISCONNECT |
| DATETIME | DISTINCT |
| DAY | DISTINCTROW |
| DEC, DECIMAL | DOMAIN |
| DECLARE | DOUBLE |
| DELETE | DROP |
| DESC |
| Eqv | FOREIGN |
|---|---|
| EXCLUSIVECONNECT | FROM |
| EXEC, EXECUTE | Klauzule FROM |
| EXISTS | GENERAL – viz LONGBINARY |
| EXTRACT | GRANT |
| FALSE | GROUP |
| FETCH | GUID |
| FIRST | HAVING |
| FLOAT, FLOAT8 – viz DOUBLE | HOUR |
| FLOAT4 – viz SINGLE |
| IDENTITY | INPUT |
|---|---|
| IEEEDOUBLE – viz DOUBLE | INSENSITIVE |
| IEEESINGLE – viz SINGLE | INSERT |
| IGNORE | INSERT INTO |
| IMAGE | INT, INTEGER, INTEGER4 – viz LONG |
| Imp | INTEGER1 – viz BYTE |
| In | INTEGER2 – viz SHORT |
| IN | INTERVAL |
| INDEX | INTO |
| INDEXCREATEDB | Is |
| INNER | ISOLATION |
| JOIN | LONGTEXT |
|---|---|
| KEY | LOWER |
| LANGUAGE | MATCH |
| LAST | Max |
| LEFT | MEMO – viz LONGTEXT |
| Level* | Min |
| Like | MINUTE |
| LOGICAL, LOGICAL1 – viz BIT | Mod |
| LONG | MONEY – viz CURRENCY |
| LONGBINARY | MONTH |
| LONGCHAR |
| NATIONAL | Outer* |
|---|---|
| NCHAR | OUTPUT |
| NONCLUSTERED | OWNERACCESS |
| Not | PAD |
| NTEXT | PARAMETERS |
| NULL | PARTIAL |
| NUMBER – viz DOUBLE | PASSWORD |
| NUMERIC – viz DECIMAL | PERCENT |
| NVARCHAR | PIVOT |
| OCTET_LENGTH | POSITION |
| OLEOBJECT – viz LONGBINARY | PRECISION |
| ON | PREPARE |
| OPEN | PRIMARY |
| OPTION | PRIVILEGES |
| Or | PROC, PROCEDURE |
| ORDER | PUBLIC |
| REAL – viz SINGLE | SMALLDATETIME |
|---|---|
| REFERENCES | SMALLINT – viz SHORT |
| RESTRICT | SMALLMONEY |
| REVOKE | SOME |
| RIGHT | SPACE |
| ROLLBACK | SQL |
| SCHEMA | SQLCODE, SQLERROR, SQLSTATE |
| SECOND | StDev |
| SELECT | StDevP |
| SELECTSCHEMA | STRING – viz TEXT |
| SELECTSECURITY | SUBSTRING |
| SET | Sum |
| SHORT | SYSNAME |
| SINGLE | SYSTEM_USER |
| SIZE |
| TABLE | UPDATEOWNER |
|---|---|
| TableID* | UPDATESECURITY |
| TEMPORARY | UPPER |
| TEXT | USAGE |
| TIME – viz DATETIME | USER |
| TIMESTAMP | USING |
| TIMEZONE_HOUR | VALUE |
| TIMEZONE_MINUTE | VALUES |
| TINYINT | Var |
| TO | VARBINARY – viz BINARY |
| TOP | VARCHAR – viz TEXT |
| TRAILING | VarP |
| TRANSACTION | VARYING |
| TRANSFORM | VIEW |
| TRANSLATE | WHEN |
| TRANSLATION | WHENEVER |
| TRIM | WHERE |
| TRUE | WITH |
| UNION | WORK |
| UNIQUE | Xor |
| UNIQUEIDENTIFIER | YEAR |
| UNKNOWN | YESNO – viz BIT |
| UPDATE | ZONE |
| UPDATEIDENTITY |