The words in Table 5-1 are reserved by Adaptive Server as keywords (part of SQL command syntax). They cannot be used as names of database objects such as databases, tables, rules, or defaults. They can be used as names of local variables and as stored procedure parameter names.
To find the names of existing objects that are reserved words, use sp_checkreswords.
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, function |
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
“New” is a special case (see “Potential SQL92 reserved words” for information on other reserved words) because it appears in the spt_values table, and because sp_checkreswords displays “New” as a reserved word. |
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 |
“New” is a potential Transact-SQL
reserved word, not a current Transact-SQL reserved word, so you
can use it to name a database object. However, since “New” may
become a reserved word in the future, Sybase recommends that you
avoid using it.
