Følgende liste indeholder alle ord, som er forbeholdt Microsoft Access-databaseprogrammet til brug i SQL-sætninger. De ord på listen, som ikke er med store bogstaver, er også reserveret af andre programmer. Derfor giver de enkelte Hjælp-emner til disse ord generelle beskrivelser, der ikke fokuserer på SQL-anvendelsen.
Bemærk!: Ord efterfulgt af en stjerne (*) er reserveret, men har i øjeblikket ingen betydning i forbindelse med en Microsoft Access SQL-sætning (f.eks . Level og TableID). Ord, der ikke er understreget, har ikke sammenkædede forklaringer.
A
ABSOLUTE |
ANY |
ADD |
ARE |
ADMINDB |
AS |
ALL |
ASC |
Alphanumeric – Se TEXT |
ASSERTION |
ALTER |
AUTHORIZATION |
ALTER TABLE |
AUTOINCREMENT – Se COUNTER |
And |
Avg |
AS |
B-C
BEGIN |
COLLATION |
Between |
COLUMN |
BINARY |
COMMIT |
BIT |
COMP, COMPRESSION |
BIT_LENGTH |
CONNECT |
BOOLEAN – Se BIT |
CONNECTION |
BOTH |
CONSTRAINT, CONSTRAINTS |
BY |
CONTAINER |
BYTE |
CONTAINS |
CASCADE |
CONVERT |
CATALOG |
Count |
CHAR, CHARACTER — Se 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 – Se DATETIME |
DISCONNECT |
DATETIME |
DISTINCT |
DAY |
DISTINCTROW |
DEC, DECIMAL |
DOMAIN |
DECLARE |
DOUBLE |
DELETE |
DROP |
DESC |
E-H
Eqv |
FOREIGN |
EXCLUSIVECONNECT |
FROM |
EXEC, EXECUTE |
FROM-delsætning |
EXISTS |
GENERAL – Se LONGBINARY |
EXTRACT |
GRANT |
FALSE |
GROUP |
FETCH |
GUID |
FIRST |
HAVING |
FLOAT, FLOAT8 – Se DOUBLE |
HOUR |
FLOAT4 – Se SINGLE |
I
IDENTITY |
INPUT |
IEEEDOUBLE – Se DOUBLE |
INSENSITIVE |
IEEESINGLE – Se SINGLE |
INSERT |
IGNORE |
INSERT INTO |
IMAGE |
INT, INTEGER, INTEGER4 – Se LONG |
Imp |
INTEGER1 – Se BYTE |
In |
INTEGER2 – Se SHORT |
IN |
INTERVAL |
INDEX |
INTO |
INDEXCREATEDB |
Is |
INNER |
ISOLATION |
J-M
JOIN |
LONGTEXT |
KEY |
LOWER |
LANGUAGE |
MATCH |
LAST |
Max |
LEFT |
MEMO – Se LONGTEXT |
Level* |
Min |
Like |
MINUTE |
LOGICAL, LOGICAL1 – Se BIT |
Mod |
LONG |
MONEY – Se CURRENCY |
LONGBINARY |
MONTH |
LONGCHAR |
N-P
NATIONAL |
Outer* |
NCHAR |
OUTPUT |
NONCLUSTERED |
OWNERACCESS |
Not |
PAD |
NTEXT |
PARAMETERS |
NULL |
PARTIAL |
NUMBER – Se DOUBLE |
PASSWORD |
NUMERIC – Se DECIMAL |
PERCENT |
NVARCHAR |
PIVOT |
OCTET_LENGTH |
POSITION |
OLEOBJECT – Se LONGBINARY |
PRECISION |
ON |
PREPARE |
OPEN |
PRIMARY |
OPTION |
PRIVILEGES |
Or |
PROC, PROCEDURE |
ORDER |
PUBLIC |
Q-S
REAL – Se SINGLE |
SMALLDATETIME |
REFERENCES |
SMALLINT – Se SHORT |
RESTRICT |
SMALLMONEY |
REVOKE |
SOME |
RIGHT |
SPACE |
ROLLBACK |
SQL |
SCHEMA |
SQLCODE, SQLERROR, SQLSTATE |
SECOND |
StDev |
SELECT |
StDevP |
SELECTSCHEMA |
STRING – Se TEXT |
SELECTSECURITY |
SUBSTRING |
SET |
Sum |
SHORT |
SYSNAME |
SINGLE |
SYSTEM_USER |
SIZE |
T-Z
TABLE |
UPDATEOWNER |
TableID* |
UPDATESECURITY |
TEMPORARY |
UPPER |
TEXT |
USAGE |
TIME — Se DATETIME |
USER |
TIMESTAMP |
USING |
TIMEZONE_HOUR |
VALUE |
TIMEZONE_MINUTE |
VALUES |
TINYINT |
Var |
TO |
VARBINARY – Se BINARY |
TOP |
VARCHAR – Se TEXT |
TRAILING |
VarP |
TRANSACTION |
VARYING |
TRANSFORM |
VIEW |
TRANSLATE |
WHEN |
TRANSLATION |
WHENEVER |
TRIM |
WHERE |
TRUE |
WITH |
UNION |
WORK |
UNIQUE |
Xor |
UNIQUEIDENTIFIER |
YEAR |
UNKNOWN |
YESNO – Se BIT |
UPDATE |
ZONE |
UPDATEIDENTITY |