SQL重命名数据内所有表名大写

想要把目标数据库里表明重命名成大写，不包括系统表。执行以下脚本就ok了！

 

 declare @name varchar(50),

@newname varchar(50)

--目标数据库xxx

use xxxx 

declare abc cursor for select [name] from dbo.sysobjects

where xtype='U'

open abc fetch next from abc into @name

 

while @@fetch_status=0 begin set @newname=upper(@name)

--大写表内字段

update syscolumns set name =upper(name) where id =object_id(@name)

 --大写表名

EXEC sp_rename @name,@newname print @name PRINT @NEWNAME

 

fetch next from abc into @name

end

 close abc

DEALLOCATE abc