MSSQL表名、列名转大写SQL语句

表名转化成大写的SQL语句

declare @sql varchar(300)
declare @tablename varchar(100)
declare cursor1 cursor for
select name from sysobjects where  xtype = 'u'
open cursor1
fetch next from cursor1 into @tablename
while @@fetch_status=0
begin
set @sql='sp_rename '''+@tablename+''','''+upper(@tablename)+''''
print @sql
exec(@sql)
fetch next from cursor1 into @tablename
end
close cursor1
deallocate cursor1

表的字段转化成大写的SQL语句

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+''','''+upper(@columnname)+''',''column'''
--print @sql
exec(@sql)
fetch next from cursor1 into @tablecolumnname,@columnname
end
close cursor1
deallocate cursor1