110,533
社区成员
发帖
与我相关
我的任务
分享
create table tb(id int)
create proc alter_tb
@tbname varchar(50),
@colname varchar(50),
@coltype varchar(50),
@type int
as
begin
if @type=1
begin
if not exists(select 1 from syscolumns where id=object_id(@tbname) and name=@colname)
exec('alter table '+@tbname+' add '+@colname+' '+@coltype)
end
else
begin
if exists(select 1 from syscolumns where id=object_id(@tbname) and name=@colname)
exec('alter table '+@tbname+' drop column '+@colname)
end
end
exec alter_tb 'tb','name','varchar(50)',1--添加
select * from tb
exec alter_tb 'tb','name','varchar(50)',2--删除
select * from tb