存储过程的问题

[wjfxyj]

存储过程如下:
CREATE procedure XjfgsSRB
@TableName varchar(30)
as
if object_id('+ @TableName + ') is not null drop table ['+ @TableName +']
begin
exec('create table [' + @TableName + '] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[lp] [varchar] (3) ,
[ch] [varchar] (7) ,
[xl] [varchar] (6)
)')
end
GO

调用：
declare @TableName varchar(30) set @TableName='F2201252' exec XjfgsSRB @TableName

如果F2201252表存在，就删除它后再建一个新表
如果F2201252表不存在，就建立一个新表
问题是不会删除原表
请各位大侠指教

[开着拖拉机泡妞]

CREATE procedure XjfgsSRB
@TableName varchar(30)
as
declare @str varchar(200)
set @str='if object_id('+''''+ @TableName + ''''+') is not null 
drop table ['+ @TableName +']'
exec(@str)
begin
  exec('create table [' + @TableName + '] (
[id] [int] IDENTITY (1, 1) NOT NULL ,  
[lp] [varchar] (3) ,
[ch] [varchar] (7) ,
[xl] [varchar] (6)   
)')
end
GO

[快溜]

exec(drop table ['''+ @TableName +'''])

[快溜]

exec('drop table ['''+ @TableName +''']')

[wjfxyj]

1楼正解，给分结贴