declare @name varchar(50), @newname varchar(50),@colname varchar(50)
declare abc cursor for
select (a.[name] + '.' + b.[name]) as tablename ,b.[name] colname
from dbo.sysobjects a ,dbo.syscolumns b where a.id = b.id
and a.xtype= 'U'
open abc
fetch next from abc into @name,@colname
while @@fetch_status=0 begin
set @newname=upper(@colname)
EXEC sp_rename @name,@newname,[COLUMN] print @colname PRINT @NEWNAME
fetch next from abc into @name,@colname
end
close abc
DEALLOCATE abc
sqlserver中将某数据库下的所有表字段名称为小写的改为大写
最新推荐文章于 2021-02-18 09:13:25 发布