alter table venconceptoval disable constraint CONCEPTO_CONVAL_FK; alter table venconceptoval disable constraint CONCEPTO_CONVALSAL_FK; alter table liqcdetalle disable constraint CONCEPTO_LIQCDETALLE_FK; alter table movimientocaja disable constraint CONCEPTO_MOVTOCAJA_FK; update concepto set concepto=replace(concepto, 'DEPOSITO','DEP') where concepto like 'DEPOSITO%'; update venconceptoval set concepto=replace(concepto, 'DEPOSITO','DEP') where concepto like 'DEPOSITO%'; update venconceptoval set conceptosalida=replace(conceptosalida, 'DEPOSITO','DEP') where conceptosalida like 'DEPOSITO%'; update liqcdetalle set concepto=replace(concepto, 'DEPOSITO','DEP') where concepto like 'DEPOSITO%'; update movimientocaja set concepto=replace(concepto, 'DEPOSITO','DEP') where concepto like 'DEPOSITO%'; select concepto from concepto where formula like '%DEPOSITO%'; alter table venconceptoval enable constraint CONCEPTO_CONVAL_FK; alter table venconceptoval enable constraint CONCEPTO_CONVALSAL_FK; alter table liqcdetalle enable constraint CONCEPTO_LIQCDETALLE_FK; alter table movimientocaja enable constraint CONCEPTO_MOVTOCAJA_FK;