alter table marketing_test2
drop column odatedw,
drop column osource,
drop column tcode,
drop column zip,
drop column mailcode,
drop column pvastate,
drop column noexch,
drop column recinhse,
drop column recp3,
drop column recpgvg,
drop column recsweep,
drop column cluster,
drop column ageflag,
drop column child03,
drop column child07,
drop column child12,
drop column child18,
drop column mbcraft,
drop column magfem,
drop column pubculin,
drop column pubopp,
drop column datasrce,
drop column localgov,
drop column stategov,
drop column fedgov,
drop column solp3,
drop column solih,
drop column major,
drop column geocode,
drop column collect1,
drop column bible,
drop column catlg,
drop column homee,
drop column pets,
drop column cdplay,
drop column stereo,
drop column pcowners,
drop column photo,
drop column crafts,
drop column fisher,
drop column gardenin,
drop column boats,
drop column walker,
drop column kidstuff,
drop column cards,
drop column plates,
drop column lifesrc,
drop column pepstrfl,
drop column pop901,
drop column pop902,
drop column pop903,
drop column pop90c1,
drop column pop90c2,
drop column pop90c3,
drop column pop90c4,
drop column pop90c5,
drop column eth1,
drop column eth2,
drop column eth3,
drop column eth4,
drop column eth5,
drop column eth6,
drop column eth7,
drop column eth8,
drop column eth9,
drop column eth10,
drop column eth11,
drop column eth12,
drop column eth13,
drop column eth14,
drop column eth15,
drop column eth16,
drop column age901,
drop column age902,
drop column age903,
drop column age904,
drop column age905,
drop column age906,
drop column age907,
drop column chil1,
drop column chil2,
drop column chil3,
drop column agec1,
drop column agec2,
drop column agec3,
drop column agec4,
drop column agec5,
drop column agec6,
drop column agec7,
drop column chilc1,
drop column chilc2,
drop column chilc3,
drop column chilc4,
drop column chilc5,
drop column hhage1,
drop column hhage2,
drop column hhage3,
drop column hhn1,
drop column hhn2,
drop column hhn3,
drop column hhn4,
drop column hhn5,
drop column hhn6,
drop column marr1,
drop column marr2,
drop column marr3,
drop column marr4,
drop column hhp1,
drop column hhp2,
drop column dw1,
drop column dw2,
drop column dw3,
drop column dw4,
drop column dw5,
drop column dw6,
drop column dw7,
drop column dw8,
drop column dw9,
drop column hv1,
drop column hv2,
drop column hv3,
drop column hv4,
drop column hu1,
drop column hu2,
drop column hu3,
drop column hu4,
drop column hu5,
drop column hhd1,
drop column hhd2,
drop column hhd3,
drop column hhd4,
drop column hhd5,
drop column hhd6,
drop column hhd7,
drop column hhd8,
drop column hhd9,
drop column hhd10,
drop column hhd11,
drop column hhd12,
drop column ethc1,
drop column ethc2,
drop column ethc3,
drop column ethc4,
drop column ethc5,
drop column ethc6,
drop column hvp1,
drop column hvp2,
drop column hvp3,
drop column hvp4,
drop column hvp5,
drop column hvp6,
drop column hur1,
drop column hur2,
drop column rhp1,
drop column rhp2,
drop column rhp3,
drop column rhp4,
drop column hupa1,
drop column hupa2,
drop column hupa3,
drop column hupa4,
drop column hupa5,
drop column hupa6,
drop column hupa7,
drop column rp1,
drop column rp2,
drop column rp3,
drop column rp4,
drop column msa,
drop column adi,
drop column dma,
drop column tpe1,
drop column tpe2,
drop column tpe3,
drop column tpe4,
drop column tpe5,
drop column tpe6,
drop column tpe7,
drop column tpe8,
drop column tpe9,
drop column ec2,
drop column afc3,
drop column anc1,
drop column anc2,
drop column anc3,
drop column anc4,
drop column anc5,
drop column anc6,
drop column anc7,
drop column anc8,
drop column anc9,
drop column anc10,
drop column anc11,
drop column anc12,
drop column anc13,
drop column anc14,
drop column anc15,
drop column pobc1,
drop column pobc2,
drop column lsc1,
drop column lsc2,
drop column lsc3,
drop column lsc4,
drop column voc1,
drop column voc2,
drop column voc3,
drop column hc1,
drop column hc2,
drop column hc3,
drop column hc4,
drop column hc5,
drop column hc6,
drop column hc7,
drop column hc8,
drop column hc9,
drop column hc10,
drop column hc11,
drop column hc12,
drop column hc13,
drop column hc14,
drop column hc15,
drop column hc16,
drop column hc17,
drop column hc18,
drop column hc19,
drop column hc20,
drop column hc21,
drop column mhuc1,
drop column mhuc2,
drop column ac1,
drop column ac2,
drop column adate_2,
drop column adate_3,
drop column adate_4,
drop column adate_5,
drop column adate_6,
drop column adate_7,
drop column adate_8,
drop column adate_9,
drop column adate_10,
drop column adate_11,
drop column adate_12,
drop column adate_13,
drop column adate_14,
drop column adate_15,
drop column adate_16,
drop column adate_17,
drop column adate_18,
drop column adate_19,
drop column adate_20,
drop column adate_21,
drop column adate_22,
drop column adate_23,
drop column adate_24,
drop column rfa_2,
drop column rfa_3,
drop column rfa_4,
drop column rfa_5,
drop column rfa_6,
drop column rfa_7,
drop column rfa_8,
drop column rfa_9,
drop column rfa_10,
drop column rfa_11,
drop column rfa_12,
drop column rfa_13,
drop column rfa_14,
drop column rfa_15,
drop column rfa_16,
drop column rfa_17,
drop column rfa_18,
drop column rfa_19,
drop column rfa_20,
drop column rfa_21,
drop column rfa_22,
drop column rfa_23,
drop column rfa_24,
drop column cardprom,
drop column maxadate,
drop column numprom,
drop column cardpm12,
drop column numprm12,
drop column rdate_3,
drop column rdate_4,
drop column rdate_5,
drop column rdate_6,
drop column rdate_7,
drop column rdate_8,
drop column rdate_9,
drop column rdate_10,
drop column rdate_11,
drop column rdate_12,
drop column rdate_13,
drop column rdate_14,
drop column rdate_15,
drop column rdate_16,
drop column rdate_17,
drop column rdate_18,
drop column rdate_19,
drop column rdate_20,
drop column rdate_21,
drop column rdate_22,
drop column rdate_23,
drop column rdate_24,
drop column ramnt_3,
drop column ramnt_4,
drop column ramnt_5,
drop column minrdate,
drop column maxrdate,
drop column lastdate,
drop column fistdate,
drop column nextdate,
drop column timelag,
drop column rfa_2r,
drop column mdmaud_r,
drop column mdmaud_f,
drop column mdmaud_a