SQL Server reserved words

Structured Query Language (SQL) is a programming language used to communicate with a database. Within SQL, certain words are reserved, which means you cannot use these words as an SQL identifier (such as the name for a table, a column, an AS alias, or other entity).

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

A

ABSOLUTE
ACTION
ADA
ADD
ALL
ALLOCATE
ALTER
AND
ANY
ARE
AS
ASC
ASSERTION
AT
AUTHORIZATION
AVG

B

BACKUP
BEGIN
BETWEEN
BIT
BIT_LENGTH
BOTH
BREAK
BROWSE
BULK
BY

C

CASCADE
CASCADED
CASE
CAST
CATALOG
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHECK
CHECKPOINT
CLOSE
CLUSTERED
COALESCE
COLLATE
COLLATION
COLUMN
COMMIT
COMPUTE
CONNECT
CONNECTION
CONSTRAINT
CONSTRAINTS
CONTAINS
CONTAINSTABLE
CONTINUE
CONVERT
CORRESPONDING
COUNT
CREATE
CROSS
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER

D

DATABASE
DATE
DAY
DBCC
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFERRABLE
DEFERRED
DELETE
DENY
DESC
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DISK
DISTINCT
DISTRIBUTED
DOMAIN
DOUBLE
DROP
DUMMY
DUMP

E

ELSE
END
END-EXEC
ERRLVL
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXIT
EXTERNAL
EXTRACT

F

FALSE
FETCH
FILE
FILLFACTOR
FIRST
FLOAT
FOR
FOREIGN
FORTRAN
FOUND
FREETEXT
FREETEXTTABLE
FROM
FULL
FUNCTION

G

GET
GLOBAL
GO
GOTO
GRANT
GROUP

H

HAVING
HOLDLOCK
HOUR

I

IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IF
IMMEDIATE
IN
INCLUDE
INDEX
INDICATOR
INITIALLY
INNER
INPUT
INSENSITIVE
INSERT
INT
INTEGER
INTERSECT
INTERVAL
INTO
IS
ISOLATION

J

JOIN

K

KEY
KILL

L

LANGUAGE
LAST
LEADING
LEFT
LEVEL
LIKE
LINENO
LOAD
LOCAL
LOWER

M

MATCH
MAX
MIN
MINUTE
MODULE
MONTH

N

NAMES
NATIONAL
NCHAR
NEXT
NO
NOCHECK
NONCLUSTERED
NONE
NOT
NULL
NULLIF
NUMERIC

O

OCTET_LENGTH
OF
OFF
OFFSETS
ON
ONLY
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
OPTION
OR
ORDER
OUTER
OUTPUT
OVER
OVERLAPS

P

PAD
PARTIAL
PASCAL
PERCENT
PLAN
POSITION
PRECISION
PREPARE
PRESERVE
PRIMARY
PRINT
PRIOR
PRIVILEGES
PROC
PROCEDURE
PUBLIC

Q

— (none explicitly listed)

R

RAISERROR
READ
READTEXT
REAL
RECONFIGURE
REFERENCES
RELATIVE
REPLICATION
RESTORE
RESTRICT
RETURN
REVOKE
RIGHT
ROLLBACK
ROWCOUNT
ROWGUIDCOL
ROWS
RULE

S

SAVE
SCHEMA
SCROLL
SECOND
SECTION
SELECT
SESSION
SESSION_USER
SET
SETUSER
SHUTDOWN
SIZE
SMALLINT
SOME
SPACE
SQL
SQLCA
SQLCODE
SQLERROR
SQLSTATE
SQLWARNING
STATISTICS
SUM
SYSTEM_USER

T

TABLE
TASKSTATUS
TEMPORARY
TEXTSIZE
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TOP
TRAILING
TRAN
TRANSACTION
TRANSLATE
TRANSLATION
TRIGGER
TRIM
TRUE
TRUNCATE
TSEQUAL

U

UNION
UNIQUE
UNKNOWN
UPDATE
UPDATETEXT
UPPER
USAGE
USE
USER
USING

V

VALUE
VALUES
VARYING
VIEW
VARCHAR

W

WAITFOR
WHEN
WHENEVER
WHERE
WHILE
WITH
WORK
WRITE
WRITETEXT

X

— (none explicitly listed)

Y

YEAR

Z

ZONE