Future Keywords

Future Keywords

Microsoft has also reserved a number of keywords for future use. These are not implemented in MS SQL Server 2000 and hence do not represent valid SQL commands. Nevertheless, it will be a good idea to avoid these altogether in your code (as identifiers, for instance) as they might render your code invalid in future versions. You may notice that some of the keywords listed here are, in fact, mandated by the SQL99 standard.

Microsoft SQL Server reserved future keywords:

ABSOLUTE

CONNECTION

EQUALS

ACTION

CONSTRAINTS

EVERY

ADMIN

CONSTRUCTOR

EXCEPTION

AFTER

CORRESPONDING

EXTERNAL

AGGREGATE

CUBE

FALSE

ALIAS

CURRENT_PATH

FIRST

ALLOCATE

CURRENT_ROLE

FLOAT

ARE

CYCLE

FOUND

ARRAY

DATA

FREE

ASSERTION

DATE

GENERAL

AT

DAY

GET

BEFORE

DEC

GLOBAL

BINARY

DECIMAL

GO

BIT

DEFERRABLE

GROUPING

BLOB

DEFERRED

HOST

BOOLEAN

DEPTH

HOUR

BOTH

DEREF

IGNORE

BREADTH

DESCRIBE

IMMEDIATE

CALL

DESCRIPTOR

INDICATOR

CASCADED

DESTROY

INITIALIZE

CAST

DESTRUCTOR

INITIALLY

CATALOG

DETERMINISTIC

INOUT

CHAR

DIAGNOSTICS

INPUT

CHARACTER

DICTIONARY

INT

CLASS

DISCONNECT

INTEGER

CLOB

DOMAIN

INTERVAL

COLLATION

DYNAMIC

ISOLATION

COMPLETION

EACH

ITERATE

CONNECT

END-EXEC

LANGUAGE

LARGE

ORDINALITY

SEARCH

LAST

OUT

SECOND

LATERAL

OUTPUT

SECTION

LEADING

PAD

SEQUENCE

LESS

PARAMETER

SESSION

LEVEL

PARAMETERS

SETS

LIMIT

PARTIAL

SIZE

LOCAL

PATH

SMALLINT

LOCALTIME

POSTFIX

SPACE

LOCALTIMESTAMP

PREFIX

SPECIFIC

LOCATOR

PREORDER

SPECIFICTYPE

MAP

PREPARE

SQL

MATCH

PRESERVE

SQLEXCEPTION

MINUTE

PRIOR

SQLSTATE

MODIFIES

PRIVILEGES

SQLWARNING

MODIFY

READS

START

MODULE

REAL

STATE

MONTH

RECURSIVE

STATEMENT

NAMES

REF

STATIC

NATURAL

REFERENCING

STRUCTURE

NCHAR

RELATIVE

TEMPORARY

NCLOB

RESULT

TERMINATE

NEW

RETURNS

THAN

NEXT

ROLE

TIME

NO

ROLLUP

TIMESTAMP

NONE

ROUTINE

TIMEZONE_HOUR

NUMERIC

ROW

TIMEZONE_MINUTE

OBJECT

ROWS

TRAILING

OLD

SAVEPOINT

TRANSLATION

ONLY

SCOPE

TREAT

OPERATION

SCROLL

TRUE

UNDER

VALUE

WORK

UNKNOWN

VARCHAR

WRITE

UNNEST

VARIABLE

YEAR

USAGE

WHENEVER

ZONE

USING

WITHOUT