存储过程怎么啦

[aierong]

create proc proc_delete_table
@tablename varchar(100)=''
as
if exists(select name from sysobjects where name=@tablename and type='u')
begin
drop table @tablename
print 'ok'
end
else
print 'no'


我是想创建一个存储过程用来删除表
@tablename变量用力存放表名称
先检测输入的表是否存在,要是存在就删除该表,并显示ok
要是表不存在就显示no

我的存储过程怎么不可以编译
请教大家,怎么办

[CrazyFor]

create proc proc_delete_table
@tablename varchar(100)=''
as
if exists(select name from sysobjects where name=@tablename and type='u')
begin
exec('drop table '+@tablename)
print 'ok'
end
else
print 'no'

[txlicenhe]

create proc proc_delete_table
@tablename varchar(100)=''
as
if exists(select name from sysobjects where name=@tablename and type='u')
begin
exec('drop table '+@tablename)
print 'ok'
end
else
print 'no'

[pengdali]

create proc proc_delete_table
@tablename varchar(100)=''
as
if exists(select name from sysobjects where name=@tablename and type='u')
begin
exec('drop table '+@tablename)
print 'ok'
end
else
print 'no'

[aierong]

谢谢大家,结帖