SQL SERVER 批量将修改字段名为大、小写

2019独角兽企业重金招聘Python工程师标准>>>

declare @sql varchar(300)
     declare @tablecolumnname varchar(100), @columnname varchar(100)
     declare cursor1 cursor for         
     select b.name+'.['+a.name+']',a.name from syscolumns a  ,sysobjects b where a.id = object_id(b.name) and b.xtype = 'u' and a.xtype <>189 and a.xtype <>34 and a.xtype <>35 and a.xtype <>36                
     open cursor1                       
     fetch next from cursor1 into @tablecolumnname,@columnname
     while @@fetch_status=0           
     begin
         set @sql='sp_rename '''+@tablecolumnname+''','''+lower(@columnname)+''',''column''' -- 此为修改为大写，如果修改为小写“lower”
         --print @sql 
         exec(@sql)             
         fetch next from cursor1 into @tablecolumnname,@columnname
     end
     close cursor1                   
     deallocate cursor1

转载于:https://my.oschina.net/sansom/blog/123980