SQL Reserved Words

Microsoft Office Access 2003

SQL Reserved Words

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

The following list includes all words reserved by the Microsoft Jet database engine for use in SQL statements . The words in the list that are not in all uppercase letters are also reserved by other applications. Consequently, the individual Help topics for these words provide general descriptions that do not focus on SQL usage.

Note  Words followed by an asterisk (*) are reserved but currently have no meaning in the context of a Microsoft® Jet SQL statement (for example, Level and TableID). Words that are not underlined do not have linked explanations.

A

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

B-C

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

I

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

J-M

JOIN LONGTEXT
KEY LOWER
LANGUAGE MATCH
LAST Max
LEFT MEMO — See LONGTEXT
Level* Min
Like MINUTE
LOGICAL, LOGICAL1 — See 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