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