sqlserver 改名

if exists (select 1
from sysobjects a,syscolumns b
where a.id = object_id('recruit_allocate') and
a.id = b.id and
b.name = 'modify_date')
exec sp_rename N'recruit_allocate.modify_date',N'allocate_date',N'column'
go