怎么样写删除表的相同字段的存储过程

[beggy]

在一个数据库中有很多表，有很大一部分表都有bbs 这个字段，要删除这个字段，该怎么写存储过程？

我是这样写的:
CREATE PROCEDURE del_col
AS
declare @tblName varchar(100);
begin

declare a_cursor cursor
for
select [name] from sysobjects where xtype='u' and status>0
open a_cursor
fetch next from a_cursor into @tblName
Exec ('alter table '+@tblName+' DROP COLUMN bbs ')
while @@Fetch_status=0
begin
fetch next from a_cursor into @tblName
Exec ('alter table '+@tblName+' DROP COLUMN bbs ')
end

close a_cursor
deallocate a_cursor

end
GO

[beggy]

对于那些没有bbs 字段的表就报错！该加个什么条件呢？

[RockEx]

...
declare a_cursor cursor
for
select b.name from syscolumns a join sysobjects b on a.id=b.id where a.name='bbs' and b.xtype='U" and b.status>0
open a_cursor
...

[pengdali]

CREATE PROCEDURE del_col
AS
declare @a varchar(255)

begin

declare a_cursor cursor for select d.name from syscolumns a,sysobjects d where a.id=d.id and d.xtype='U' and a.name='bbs'
open a_cursor
fetch next from a_cursor into @a
while @@Fetch_status=0
begin
Exec ('alter table '+@a+' DROP COLUMN bbs ')
fetch next from a_cursor into @a
end

close a_cursor
deallocate a_cursor

end
GO

[beggy]

谢谢两位！大力哥的大名早有所闻，果然厉害！