```sql
alter table zd_health_education_type add parent varchar(12);
alter table zd_health_education add del_flag tinyint not null default 0
```

```sql
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

```

```sql
alter table ward_rounds add pat_no varchar(32) not null , times int  not null, pat_name nvarchar(32)  not null
```