alter table db_masters.emp_healthcard alter column bloodgroup int
alter table db_masters.emp_healthcard alter column rhfactor int

alter table db_masters.emp_relations add name varchar(200),dob date,genderid int,bloodgroup int,relation int
alter table db_masters.employee add [filename] varchar(200)
alter  TABLE [db_masters].[levies] add isinwardlevy bit default(0)
drop table db_mktg.quote_dtl_sale_batches
drop table db_mktg.quote_dtl_sale_exportcarriage
alter table db_masters.employee add emp_image varchar(500)
alter table db_hr.dtl_resumeexperience add [lastindustrysegment] int
alter table db_hr.hdr_resume add co_deptid int
alter table db_sop.mst_ordertype add isexportterms bit
alter TABLE [db_sop].[mst_ordertype] add orderrequired [bit] default(1)
alter table [db_hr].[trg_hdr_calender] add trainingcost decimal(9,2),trainingbtchsize int