Reserved Keywords

These are SQL Server reserved keywords. The new reserved words (identified by "reserved") can be used as identifiers with SQL Server 6.5 but can be expected to cause syntax conflicts in future versions of SQL Server. Keywords followed by a * were first used in SQL Server 6.0. Keywords followed by a ** were first used in SQL Server 6.5.

The following keywords and reserved words are checked by the Chkupg.exe utility, which checks keywords but does not change them. The second set of keywords are not checked by Chkupg.exe. Run the Chkupg.exe utility before you upgrade.

*
**

= First used in SQL Server 6.0
= First used in SQL Server 6.5


A

ABSOLUTE

ARE

ACTION (reserved)

ASSERTION (reserved)

ADD *

AT

ALLOCATE

AUTHORIZATION **


B

BOTH


C

CASCADE **

CONNECT

CASCADED

CONNECTION

CASE

CONSTRAINT *

CAST

CONSTRAINTS

CATALOG

CORRESPONDING

CHAR_LENGTH

CROSS **

CHARACTER (reserved)

CURRENT *

CHARACTER_LENGTH

CURRENT_DATE *

CLOSE *

CURRENT_TIME *

COALESCE *

CURRENT_TIMESTAMP *

COLLATE

CURRENT_USER *

COLLATION

CURSOR *

COLUMN


D

DATE

DESCRIPTOR

DAY

DIAGNOSTICS

DEALLOCATE *

DISCONNECT

DEFERRABLE

DISTRIBUTED

DEFERRED (reserved)

DOMAIN

DESCRIBE

DOUBLE


E

END_EXEC

EXPIREDATE (reserved)

ESCAPE **

EXTERNAL

EXCEPTION

EXTRACT


F

FALSE

FLOPPY *

FETCH *

FOREIGN *

FILE (reserved)

FULL **

FIRST


G

GET

GLOBAL


H

HOUR


I

IDENTITY *

INNER **

IDENTITY_INSERT *

INPUT

IDENTITYCOL *

INSENSITIVE *

IMMEDIATE (reserved)

INTERVAL

INITIALLY (reserved)

ISOLATION *


J

JOIN **


K

KEY *


L

LAST

LEVEL *

LEADING

LOCAL

LEFT **


M

MATCH (reserved)

MONTH

MINUTE


N

NAMES

NEXT

NATIONAL (reserved)

NO

NATURAL

NOCHECK *

NCHAR

NULLIF *


O

OCTET_LENGTH

OPTION *

OF *

OUTER **

ONLY *

OUTPUT

OPEN *

OVERLAPS


P

PAD

PRESERVE

PARTIAL (reserved)

PRIMARY *

PIPE *

PRIOR

POSITION

PRIVILEGES **

PRECISION


R

READ *

RESTRICT **

REFERENCES *

RETAINDAYS (reserved)

RELATIVE

RIGHT **

REPLICATION *

ROWS


S

SCHEMA **

SIZE

SCROLL *

SOME *

SECOND

SPACE

SERIALIZABLE *

SQLSTATE

SESSION

SUM

SESSION_USER *

SYSTEM_USER *


T

THEN *

TRAILING

TIME

TRANSLATE

TIMESTAMP

TRANSLATION

TIMEZONE_HOUR

TRUE

TIMEZONE_MINUTE


U

UNCOMMITTED *

USAGE

UNKNOWN

USER *

UPDATETEXT *

USING


V

VALUE

VOLUME (reserved)

VARYING *


W

WHEN

WRITE

WORK **


Y

YEAR


Z

ZONE