alter table zd_health_education_type add parent varchar(12);
alter table zd_health_education add del_flag tinyint not null default 0
exec sp_rename 'zd_health_education.sort_no', sort, 'COLUMN'
go
exec sp_rename 'zd_health_education.zd_health_education_sort_no_name_index', zd_health_education_sort_name_index,
'INDEX'
go
alter table ward_rounds add pat_no varchar(32) not null , times int not null, pat_name nvarchar(32) not null