--启用对系统目录的特殊更新
USE master
sp_configure 'allow updates',1
GO
RECONFIGURE WITH OVERRIDE
GO
use hyys
select * from sysobjects where xtype='U'
update sysobjects
set name=lower(name)
where xtype='U'
select * from syscolumns where id>10000
update syscolumns
set name=lower(name)
where id>10000
--禁用对系统目录的特殊更新
USE master
GO
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO