En la lista siguiente se incluyen todas las palabras reservadas por el motor de base de datos de Microsoft Access para su uso en instrucciones SQL. Las palabras de la lista que no están en letras mayúsculas también están reservadas por otras aplicaciones. Por tanto, en los temas de ayuda individuales para estas palabras se proporcionan descripciones generales que no se centran en el uso de SQL.
Nota: Las palabras seguidas por un asterisco (*) están reservadas, pero actualmente no tienen ningún significado en el contexto de una instrucción SQL de Microsoft Access (por ejemplo, Level y TableID). Las palabras que no se subrayan no tienen explicaciones vinculadas.
A
ABSOLUTE |
ANY |
ADD |
ARE |
ADMINDB |
AS |
ALL |
ASC |
Alphanumeric: vea TEXT |
ASSERTION |
ALTER |
AUTHORIZATION |
ALTER TABLE |
AUTOINCREMENT: vea COUNTER |
And |
Avg |
AS |
B-C
BEGIN |
COLLATION |
Between |
COLUMN |
BINARY |
COMMIT |
BIT |
COMP, COMPRESSION |
BIT_LENGTH |
CONNECT |
BOOLEAN: vea BIT |
CONNECTION |
BOTH |
CONSTRAINT, CONSTRAINTS |
BY |
CONTAINER |
BYTE |
CONTAINS |
CASCADE |
CONVERT |
CATALOG |
Count |
CHAR, CHARACTER: vea 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: vea DATETIME |
DISCONNECT |
DATETIME |
DISTINCT |
DAY |
DISTINCTROW |
DEC, DECIMAL |
DOMAIN |
DECLARE |
DOUBLE |
DELETE |
DROP |
DESC |
E-H
Eqv |
FOREIGN |
EXCLUSIVECONNECT |
FROM |
EXEC, EXECUTE |
Cláusula FROM |
EXISTS |
GENERAL: vea LONGBINARY |
EXTRACT |
GRANT |
FALSE |
GROUP |
FETCH |
GUID |
FIRST |
HAVING |
FLOAT, FLOAT8: vea DOUBLE |
HOUR |
FLOAT4: vea SINGLE |
I
IDENTITY |
INPUT |
IEEEDOUBLE: vea DOUBLE |
INSENSITIVE |
IEEESINGLE: vea SINGLE |
INSERT |
IGNORE |
INSERT INTO |
IMAGE |
INT, INTEGER, INTEGER4: vea LONG |
Imp |
INTEGER1: vea BYTE |
In |
INTEGER2: vea SHORT |
IN |
INTERVAL |
INDEX |
INTO |
INDEXCREATEDB |
Is |
INNER |
ISOLATION |
J-M
JOIN |
LONGTEXT |
KEY |
LOWER |
LANGUAGE |
MATCH |
LAST |
Max |
LEFT |
MEMO: vea LONGTEXT |
Level* |
Min |
Like |
MINUTE |
LOGICAL, LOGICAL1: vea BIT |
Mod |
LONG |
MONEY: vea CURRENCY |
LONGBINARY |
MONTH |
LONGCHAR |
N-P
NATIONAL |
Outer* |
NCHAR |
OUTPUT |
NONCLUSTERED |
OWNERACCESS |
Not |
PAD |
NTEXT |
PARAMETERS |
NULL |
PARTIAL |
NUMBER: vea DOUBLE |
PASSWORD |
NUMERIC: vea DECIMAL |
PERCENT |
NVARCHAR |
PIVOT |
OCTET_LENGTH |
POSITION |
OLEOBJECT: vea LONGBINARY |
PRECISION |
ON |
PREPARE |
OPEN |
PRIMARY |
OPTION |
PRIVILEGES |
Or |
PROC, PROCEDURE |
ORDER |
PUBLIC |
Q-S
REAL: vea SINGLE |
SMALLDATETIME |
REFERENCES |
SMALLINT: vea SHORT |
RESTRICT |
SMALLMONEY |
REVOKE |
SOME |
RIGHT |
SPACE |
ROLLBACK |
SQL |
SCHEMA |
SQLCODE, SQLERROR, SQLSTATE |
SECOND |
StDev |
SELECT |
StDevP |
SELECTSCHEMA |
STRING: vea TEXT |
SELECTSECURITY |
SUBSTRING |
SET |
Sum |
SHORT |
SYSNAME |
SINGLE |
SYSTEM_USER |
SIZE |
T-Z
TABLE |
UPDATEOWNER |
TableID* |
UPDATESECURITY |
TEMPORARY |
UPPER |
TEXT |
USAGE |
TIME: vea DATETIME |
USER |
TIMESTAMP |
USING |
TIMEZONE_HOUR |
VALUE |
TIMEZONE_MINUTE |
VALUES |
TINYINT |
Var |
TO |
VARBINARY: vea BINARY |
TOP |
VARCHAR: vea TEXT |
TRAILING |
VarP |
TRANSACTION |
VARYING |
TRANSFORM |
VIEW |
TRANSLATE |
WHEN |
TRANSLATION |
WHENEVER |
TRIM |
WHERE |
TRUE |
WITH |
UNION |
WORK |
UNIQUE |
Xor |
UNIQUEIDENTIFIER |
YEAR |
UNKNOWN |
YESNO: vea BIT |
UPDATE |
ZONE |
UPDATEIDENTITY |