Alter table wko_det add wko_det_rea_rmk varchar (255) null DELETE cf_label WHERE table_name = 'wko_det' AND column_name = 'wko_det_rea_rmk' GO INSERT cf_label (language_cd, table_name, column_name, default_label, customize_label, default_header, customize_header, cfr_flag, cf_label_required, audit_user, audit_date ) SELECT language_cd, 'wko_det', 'wko_det_rea_rmk', 'Reassign Remarks:', 'Reassign Remarks:', 'Reassign Remarks', 'Reassign Remarks', '0', '0', 'admin', getdate() FROM cf_language GO