修改所有表的同一个字段

declare @cloum varchar(50)

declare @sqlStr varchar(1000)

--申请表名

declare @tablename varchar(50)

set @cloum='FStationNo'

--申明一个游标

DECLARE MyCursor CURSOR

FOR select name from sysobjects where xtype='u'

--打开一个游标

OPEN MyCursor

FETCH NEXT FROM MyCursor INTO @tablename

WHILE @@FETCH_STATUS =0

begin

begin try

if exists(select name from syscolumns where id=(select max(id) from sysobjects where xtype='u' and name=@tablename ) and name=@cloum)

begin

set @sqlStr='alter table '+@tablename +' alter COLUMN FStationNo varchar(6)'

print @sqlStr

-- exec(@sqlStr)

end

FETCH NEXT FROM MyCursor INTO @tablename

end try

begin catch

end catch

end

--关闭游标

CLOSE MyCursor

--释放资源

DEALLOCATE MyCursor