ALTER TABLE ESCOPOSUBSCOMPMENU DROP CONSTRAINT FKCOC00668MANUALCIAM
/
DROP INDEX FKCOC00668MANUALCIAM
/
ALTER TABLE ESCOPOSUBSCOMPMENU DROP CONSTRAINT FKCOC00669SERVMANUALM
/
DROP INDEX FKCOC00669SERVMANUALM
/
ALTER TABLE ESCOPOSUBSCOMPMENU DROP CONSTRAINT FKCOC00670UBGRUSEMAM
/
DROP INDEX FKCOC00670UBGRUSEMAM
/
ALTER TABLE ESCOPOSUBSCOMPMENU DROP CONSTRAINT FKCOC00671CICLOSUBGRUSEMAM
/
DROP INDEX FKCOC00671CICLOSUBGRUSEMAM
/
CREATE INDEX ESCOPOSUBSCOMPMENU_01 ON ESCOPOSUBSCOMPMENU (CDFILIAL, CDCIA, CDMANCIA, NRSERVICOCIAFILI, CDCLASSE, CDSUBGRU, NRSEQSUBGRUSEMAM, CDCICLO,NRORG)
/
ALTER TABLE EDITSUBSCOMPMENU DROP CONSTRAINT FKCOC00673EDITPRODSUBSEMAM
/
DROP INDEX FKCOC00673EDITPRODSUBSEMAM
/
CREATE INDEX EDITSUBSCOMPMENU_01 ON EDITSUBSCOMPMENU (CDFILIAL, CDCIA, CDMANCIA, NRSERVICOCIAFILI, CDCLASSE, CDSUBGRU, NRSEQSUBGRUSEMAM, CDCICLO, CDPRODUTO,NRORG)
/
ALTER TABLE EDITSUBSCOMPMENU DROP CONSTRAINT FKCOC00674EDITRECSUBSEMAM
/
DROP INDEX FKCOC00674EDITRECSUBSEMAM
/
CREATE INDEX EDITSUBSCOMPMENU_02 ON EDITSUBSCOMPMENU (CDFILIAL, CDCIA, CDMANCIA, NRSERVICOCIAFILI, CDCLASSE, CDSUBGRU, NRSEQSUBGRUSEMAM, CDCICLO, CDRECEITA,NRORG)