Palavras reservadas SQL

Aplica-se ao: Access 2013, Office 2013

A lista a seguir inclui todas as palavras reservadas pelo mecanismo de banco de dados do Microsoft Access para uso nas instruções SQL.

• As palavras na lista que não estão escritas totalmente em letras maiúsculas também são reservadas por outros aplicativos. Consequentemente, os tópicos individuais de Ajuda para essas palavras fornecem descrições gerais que não se resumem ao uso de SQL.

• As palavras seguidas por um asterisco (*) são reservadas, mas atualmente não têm sentido no contexto de uma instrução SQL do Microsoft Access (por exemplo, Level e TableID).

• As palavras que não estão sublinhadas não têm explicações vinculadas.

A

ABSOLUTE	ANY
ADD	ARE
ADMINDB	AS
ALL	ASC
Alphanumeric — Consulte TEXT	ASSERTION
ALTER	AUTHORIZATION
ALTER TABLE	AUTOINCREMENT — Consulte COUNTER
And	Avg
AS

B-C

BEGIN	COLLATION
Between	COLUMN
BINARY	COMMIT
BIT	COMP, COMPRESSION
BIT_LENGTH	CONNECT
BOOLEAN — Consulte BIT	CONNECTION
BOTH	CONSTRAINT, CONSTRAINTS
BY	CONTAINER
BYTE	CONTAINS
CASCADE	CONVERT
CATALOG	Count
CHAR, CHARACTER — Consulte 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 — Consulte 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 — Consulte LONGBINARY
EXTRACT	GRANT
FALSE	GROUP
FETCH	GUID
FIRST	HAVING
FLOAT, FLOAT8 — Consulte DOUBLE	HOUR
FLOAT4 — Consulte SINGLE

I

IDENTITY	INPUT
IEEEDOUBLE — Consulte DOUBLE	INSENSITIVE
IEEESINGLE — Consulte SINGLE	INSERT
IGNORE	INSERT INTO
IMAGE	INT, INTEGER, INTEGER4 — Consulte LONG
Imp	INTEGER1 — Consulte BYTE
In	INTEGER2 — Consulte SHORT
IN	INTERVAL
INDEX	INTO
INDEXCREATEDB	Is
INNER	ISOLATION

J-M

JOIN	LONGTEXT
KEY	LOWER
LANGUAGE	MATCH
LAST	Max
LEFT	MEMO — Consulte LONGTEXT
Level*	Min
Like	MINUTE
LOGICAL, LOGICAL1 — Consulte BIT	Mod
LONG	MONEY — Consulte CURRENCY
LONGBINARY	MONTH
LONGCHAR

N-P

NATIONAL	Outer*
NCHAR	OUTPUT
NONCLUSTERED	OWNERACCESS
Not	PAD
NTEXT	PARAMETERS
NULL	PARTIAL
NUMBER — Consulte DOUBLE	PASSWORD
NUMERIC — Consulte DECIMAL	PERCENT
NVARCHAR	PIVOT
OCTET_LENGTH	POSITION
OLEOBJECT — Consulte LONGBINARY	PRECISION
ON	PREPARE
OPEN	PRIMARY
OPTION	PRIVILEGES
Or	PROC, PROCEDURE
ORDER	PUBLIC

Q-S

REAL — Consulte SINGLE	SMALLDATETIME
REFERENCES	SMALLINT — Consulte SHORT
RESTRICT	SMALLMONEY
REVOKE	SOME
RIGHT	SPACE
ROLLBACK	SQL
SCHEMA	SQLCODE, SQLERROR, SQLSTATE
SECOND	StDev
SELECT	StDevP
SELECTSCHEMA	STRING — Consulte TEXT
SELECTSECURITY	SUBSTRING
SET	Sum
SHORT	SYSNAME
SINGLE	SYSTEM_USER
SIZE

T-Z

TABLE	UPDATEOWNER
TableID*	UPDATESECURITY
TEMPORARY	UPPER
TEXT	USAGE
TIME — Consulte DATETIME	USER
TIMESTAMP	USING
TIMEZONE_HOUR	VALUE
TIMEZONE_MINUTE	VALUES
TINYINT	Var
TO	VARBINARY — Consulte BINARY
TOP	VARCHAR — Consulte TEXT
TRAILING	VarP
TRANSACTION	VARYING
TRANSFORM	VIEW
TRANSLATE	WHEN
TRANSLATION	WHENEVER
TRIM	WHERE
TRUE	WITH
UNION	WORK
UNIQUE	Xor
UNIQUEIDENTIFIER	YEAR
UNKNOWN	YESNO — Consulte BIT
UPDATE	ZONE
UPDATEIDENTITY