declare hcforeach cursor global
for
select 'exec sp_rename '+quotename(a.name+'.'+b.name,'''')+','+quotename(replace(b.name,'abc','aaa'),'''')
--select 'exec sp_rename '+a.name+'.'+quotename(b.name,'''')+','+quotename(replace(b.name,'abc','aaa'),'''')
from sysobjects a,syscolumns b
where a.id=b.id
and
objectproperty(a.id,'isusertable')=1
and
b.name like '%abc%'
exec sp_msforeach_worker '?'
重命名字段:
--------------------------------------------------------------------------------------------------------------------
declare hcforeach cursor global
for
select 'exec sp_rename '+a.name+'.'+quotename(b.name,'''')+','+quotename(replace(b.name,'abc','aaa'),'''')
from sysobjects a,syscolumns b
where a.id=b.id
and
objectproperty(a.id,'isusertable')=1
and
b.name like '%abc%'
exec sp_msforeach_worker '?'
1.
declare hcforeach cursor global
for
select 'exec sp_rename '+quotename(name,'''')+','+quotename(replace(name,'abc','aaa'),'''')
from sysobjects
where objectproperty(id,'isusertable')=1
and name like '%abc%'
exec sp_msforeach_worker '?'