Sledeća lista sadrži sve reči koje su rezervisane od strane mašine Microsoft Access baze podataka za upotrebu u SQL izrazima. Reči na listi koje nisu napisane velikim slovima takođe su rezervisane od strane drugih aplikacija. Zbog toga pojedinačne teme pomoći za ove reči pružaju opšte opise koji nisu fokusirani na upotrebu SQL-a.
Napomena: Reči iza kojih sledi zvezdica (*) rezervisane su, ali trenutno nemaju značenje u kontekstu Microsoft Access SQL izraza (na primer, Nivo i ID tabele). Reči koje nisu podvučene nemaju povezana objašnjenja.
A
ABSOLUTE |
ANY |
ADD |
ARE |
ADMINDB |
AS |
ALL |
ASC |
Alfanumerički – Pogledajte TEXT |
ASSERTION |
ALTER |
AUTHORIZATION |
ALTER TABLE |
AUTOINCREMENT – Pogledajte COUNTER |
And |
Avg |
AS |
B-C
BEGIN |
COLLATION |
Between |
COLUMN |
BINARY |
COMMIT |
BIT |
COMP, COMPRESSION |
BIT_LENGTH |
CONNECT |
BOOLEAN — Pogledajte BIT |
CONNECTION |
BOTH |
CONSTRAINT, CONSTRAINTS |
BY |
CONTAINER |
BYTE |
CONTAINS |
CASCADE |
CONVERT |
CATALOG |
Count |
CHAR, CHARACTER — Pogledajte 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 – Pogledajte DATETIME |
DISCONNECT |
DATETIME |
DISTINCT |
DAY |
DISTINCTROW |
DEC, DECIMAL |
DOMAIN |
DECLARE |
DOUBLE |
DELETE |
DROP |
DESC |
E-H
Eqv |
FOREIGN |
EXCLUSIVECONNECT |
FROM |
EXEC, EXECUTE |
FROM Clause |
EXISTS |
GENERAL — Pogledajte LONGBINARY |
EXTRACT |
GRANT |
FALSE |
GROUP |
FETCH |
GUID |
FIRST |
HAVING |
FLOAT, FLOAT8 — Pogledajte DOUBLE |
HOUR |
FLOAT4 – Pogledajte SINGLE |
I
IDENTITY |
INPUT |
IEEEDOUBLE – Pogledajte DOUBLE |
INSENSITIVE |
IEEESINGLE — Pogledajte SINGLE |
INSERT |
IGNORE |
INSERT INTO |
IMAGE |
INT, INTEGER, INTEGER4 — Pogledajte LONG |
Imp |
INTEGER1 – Pogledajte BYTE |
In |
INTEGER2 — Pogledajte SHORT |
IN |
INTERVAL |
INDEX |
INTO |
INDEXCREATEDB |
Is |
INNER |
ISOLATION |
J-M
JOIN |
LONGTEXT |
KEY |
LOWER |
LANGUAGE |
MATCH |
LAST |
Max |
LEFT |
MEMO — Pogledajte LONGTEXT |
Level* |
Min |
Like |
MINUTE |
LOGICAL, LOGICAL1 — Pogledajte BIT |
Mod |
LONG |
MONEY — See 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 — See BINARY |
TOP |
VARCHAR — See 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 |