|
Category: ASE: Reserved Words
Transact-SQL reserved words, T-SQL reserved words
Transact-SQL
knows a number of reserved words, listed below:
-
add
-
all
-
alter
-
-
and
-
any
-
arith_overflow
-
as
-
asc
-
at
-
authorization
-
avg
-
begin
-
between
-
break
-
browse
-
bulk
-
by
-
cascade
-
case
-
char_convert
-
check
-
checkpoint
-
close
-
clustered
-
coalesce
-
commit
-
compute
-
confirm
-
connect
-
constraint
-
continue
-
controlrow
-
convert
-
count
-
create
-
current
-
cursor
-
database
-
dbcc
-
deallocate
-
declare
-
default
-
delete
-
desc
-
deterministic
-
disk
-
distinct
-
double
-
drop
-
dummy
-
dump
-
else
-
end
-
endtran
-
errlvl
-
errordata
-
errorexit
-
escape
-
except
-
exclusive
-
exec
-
execute
-
exists
-
exit
-
exp_row_size
-
external
-
fetch
-
fillfactor
-
for
-
foreign
-
from
-
func
-
function
-
goto
-
grant
-
group
-
having
-
holdlock
-
identity
-
identity_gap
-
identity_insert
-
identity_start
-
if
-
in
-
index
-
inout
-
insert
-
install
-
intersect
-
into
-
is
-
isolation
-
jar
-
join
-
key
-
kill
-
level
-
like
-
lineno
-
load
-
lock
-
max
-
max_rows_per_page
-
min
-
mirror
-
mirrorexit
-
modify
-
national
-
new
-
noholdlock
-
nonclustered
-
not
-
null
-
nullif
-
numeric_truncation
-
of
-
off
-
offsets
-
on
-
once
-
online
-
only
-
open
-
option
-
or
-
order
-
out
-
output
-
over
-
partition
-
perm
-
permanent
-
plan
-
precision
-
prepare
-
primary
-
print
-
privileges
-
proc
-
procedure
-
processexit
-
proxy_table
-
public
-
quiesce
-
raiserror
-
read
-
readpast
-
readtext
-
reconfigure
-
references remove
-
reorg
-
replace
-
replication
-
reservepagegap
-
return
-
returns
-
revoke
-
role
-
rollback
-
rowcount
-
rows
-
rule
-
save
-
schema
-
select
-
set
-
setuser
-
shared
-
shutdown
-
some
-
statistics
-
stringsize
-
stripe
-
sum
-
syb_identity
-
syb_restree
-
syb_terminate
-
table
-
temp
-
temporary
-
textsize
-
to
-
tran
-
transaction
-
trigger
-
truncate
-
tsequal
-
union
-
unique
-
unpartition
-
update
-
use
-
user
-
user_option
-
using
-
values
-
varying
-
view
-
waitfor
-
when
-
where
-
while
-
with
-
work
-
writetext
The word new is currently not a reserved word in T-SQL, yet.
It is possible though that it will be added to the list of reserved words in future. It is therefore
recommended to avoid using this word. Moreover, the word "new" is already treated as a special
case, because it is listed in the
sp_values
table.
This is the reason why "new" is displayed when executing the
sp_checkreswords
command.
|
