Transact-SQL reserved words

These are reserved by Adaptive Server as keywords (part of SQL command syntax).

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, count_big, create, current, cursor

D

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

E

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

F

fetch, fillfactor, for, foreign, from

G

goto, grant, group

H

having, holdlock

I

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

J

jar, join

K

key, kill

L

level, like, lineno, load, lock

M

materialized, 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, 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, scroll, select, semi_sensitive, set, setuser, shared, shutdown, some, statistics, stringsize, stripe, sum, syb_identity, syb_restree, syb_terminate

T

table, temp, temporary, textsize, to, tracefile, 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

X

xmlextract, xmlparse, xmltest