sqlserver中将某数据库下的所有表字段名称为小写的改为大写

发布时间：2020-12-12 13:24:57 所属栏目：MsSql教程来源：网络整理

导读：declare ?@ name ? varchar (50),?@newname? 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

declare?@name?varchar(50),?@newname?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?@COLUMN]?print?@colname?PRINT?@NEWNAME??
end??
close?abc??
DEALLOCATE?abc??

/***更改字段名称之前需要执行下名两行语句 ?分步执行否则更改字段名称时偶尔会不好用***/?

sp_configure 'allow updates',1 ??

RECONFIGURE WITH OVERRIDE

/***更改字段名称之后需要执行下名两行语句 ?分步执行 ***/?

RECONFIGURE WITH OVERRIDE

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!