[Resolvido] Palavras reservadas

[xanburzum 169]

O motor de base de dados Microsoft Jet é executado em vários modos diferentes dependendo se é denominado a partir do Microsoft Access, os objectos de acesso a dados, Microsoft OLE DB Provider para Microsoft Jet, ou o controlador ODBC do Microsoft Access. Poder ser executada no modo ANSI ou no modo que não seja ANSI (tradicional).

 

Cada um destes modos resulta num conjunto ligeiramente diferente de palavras reservadas. As consultas escritas num modo podem utilizar uma palavra reservada como um identificador e falhasse de outro modo por causa disto.

 

Abaixo uma lista de palavras reservadas para evitar quando escolher nomes identificador.

 

 

 

Palavras reservadas

 

A

ABSOLUTE ACTION ADD ADMINDB

ALL ALLOCATE ALPHANUMERIC ALTER

AND ANY ARE AS

ASC ASSERTION AT AUTHORIZATION

AUTOINCREMENT AVG

 

B

BAND BEGIN BETWEEN BINARY

BIT BIT_LENGTH BNOT BOR

BOTH BXOR BY BYTE

 

C

CASCADE CASCADED CASE CAST

CATALOG CHAR CHARACTER CHAR_LENGTH

CHARACTER_LENGTH CHECK CLOSE COALESCE

COLLATE COLLATION COLUMN COMMIT

COMP COMPRESSION CONNECT CONNECTION

CONSTRAINT CONSTRAINTS CONTAINER CONTINUE

CONVERT CORRESPONDING COUNT COUNTER

CREATE CREATEDB CROSS CURRENCY

CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP

CURRENT_USER CURSOR

 

D

DATABASE DATE DATETIME DAY

DEALLOCATE DEC DECIMAL DECLARE

DEFAULT DEFERRABLE DEFERRED DELETE

DESC DESCRIBE DESCRIPTOR DIAGNOSTICS

DISALLOW DISCONNECT DISTINCT DOMAIN

DOUBLE DROP

 

E

ELSE END END-EXEC ESCAPE

EXCEPT EXCEPTION EXCLUSIVECONNECT EXEC

EXECUTE EXISTS EXTERNAL EXTRACT

 

F

FALSE FETCH FIRST FLOAT

FLOAT4 FLOAT8 FOR FOREIGN

FOUND FROM FULL

 

G

GENERAL GET GLOBAL GO

GOTO GRANT GROUP GUID

 

H

HAVING HOUR

 

I

IDENTITY IEEEDOUBLE IEEESINGLE IGNORE

IMAGE IMMEDIATE IN INDEX

INDICATOR INHERITABLE INITIALLY INNER

INPUT INSENSITIVE INSERT INT

INTEGER INTEGER1 INTEGER2 INTEGER4

INTERSECT INTERVAL INTO IS

ISOLATION

 

J

JOIN

 

K

KEY

 

L

LANGUAGE LAST LEADING LEFT

LEVEL LIKE LOCAL LOGICAL

LOGICAL1 LONG LONGBINARY LONGCHAR

LONGTEXT LOWER

 

M

MATCH MAX MEMO MIN

MINUTE MODULE MONEY MONTH

 

N

NAMES NATIONAL NATURAL NCHAR

NEXT NO NOT NOTE

NULL NULLIF NUMBER NUMERIC

 

O

OBJECT OCTET_LENGTH OF OLEOBJECT

ON ONLY OPEN OPTION

OR ORDER OUTER OUTPUT

OVERLAPS OWNERACCESS

 

P

PAD PARAMETERS PARTIAL PASSWORD

PERCENT PIVOT POSITION PRECISION

PREPARE PRESERVE PRIMARY PRIOR

PRIVILEGES PROC PROCEDURE PUBLIC

 

Q

 

R

READ REAL REFERENCES RELATIVE

RESTRICT REVOKE RIGHT ROLLBACK

ROWS

 

S

SCHEMA SCROLL SECOND SECTION

SELECT SELECTSCHEMA SELECTSECURITY SESSION

SESSION_USER SET SHORT SINGLE

SIZE SMALLINT SOME SPACE

SQL SQLCODE SQLERROR SQLSTATE

STRING SUBSTRING SUM SYSTEM_USER

 

T

TABLE TABLEID TEMPORARY TEXT

THEN TIME TIMESTAMP TIMEZONE_HOUR

TIMEZONE_MINUTE TO TOP TRAILING

TRANSACTION TRANSFORM TRANSLATE TRANSLATION

TRIM TRUE

 

U

UNION UNIQUE UNIQUEIDENTIFIER UNKNOWN

UPDATE UPDATEIDENTITY UPDATEOWNER UPDATESECURITY

UPPER USAGE USER USING

 

V

VALUE VALUES VARBINARY VARCHAR

VARYING VIEW

 

W

WHEN WHENEVER WHERE WITH

WORK WRITE

 

X

 

Y

YEAR YESNO

 

Z

ZONE

 

Iniciar com Microsoft Data Access Components (MDAC) versão 2.6, já não MDAC contém os seguintes componentes Jet:

 

• Microsoft Jet

• Fornecedor de OLE DB do Microsoft Jet

• ODBC Desktop Database Drivers