Transact-SQL reserved words

Words

A

add, all, alter, and, any, arith_overflow, as, asc, at, authorization, avg

B

begin, between, break, browse, bulk, by

C

cascade, case, char_convert, check, checkpoint, close, clustered, coalesce, commit, compute, confirm, connect, constraint, continue, controlrow, convert, count, create, current, cursor

D

database, dbcc, deallocate, declare, default, delete, desc, deterministic, disk distinct, double, drop, dummy, dump

E

else, end, endtran, errlvl, errordata, errorexit, escape, except, exclusive, exec, execute, exists, exit, exp_row_size, external

F

fetch, fillfactor, for, foreign, from, func

G

goto, grant, group

H

having, holdlock

I

identity, identity_gap, identity_insert, identity_start, if, in, index, inout, insert, install, intersect, into, is, isolation

J

jar, join

K

key, kill

L

level, like, lineno, load, lock

M

max, max_rows_per_page, min, mirror, mirrorexit, modify

N

national, new, noholdlock, nonclustered, not, null, nullif, numeric_truncation

O

of, off, offsets, on, once, online, only, open, option, or, order, out, output, over

P

partition, perm, permanent, plan, precision, prepare, primary, print, privileges, proc, procedure, processexit, proxy_table, public

Q

quiesce

R

raiserror, read, readpast, readtext, reconfigure, references remove, reorg, replace, replication, reservepagegap, return, returns, revoke, role, rollback, rowcount, rows, rule

S

save, schema, select, set, setuser, shared, shutdown, some, statistics, stringsize, stripe, sum, syb_identity, syb_restree, syb_terminate

T

table, temp, temporary, textsize, to, tran, transaction, trigger, truncate, tsequal

U

union, unique, unpartition, update, use, user, user_option, using

V

values, varying, view

W

waitfor, when, where, while, with, work, writetext