ALTER TABLE CONCPREORCAGOP DROP CONSTRAINT FKGOP00682CALENPREORCAGOP
/
ALTER TABLE DEDURECEITAROP MODIFY CDTIPOOPER VARCHAR2(02) NULL
/
ALTER TABLE DEDURECEITAROP MODIFY IDENTRSAIDOP VARCHAR2(01) NULL
/
ALTER TABLE DEDURECEITAROP DROP CONSTRAINT CKC_IDENTRSAIDOP_DEDURECEITA
/
ALTER TABLE DEDURECEITAROP ADD CONSTRAINT CKC_IDENTRSAIDOP_DEDURECEITA CHECK (IDENTRSAIDOP IS NULL OR (IDENTRSAIDOP IN ('E','S')))
/
ALTER TABLE DEDURECEITAROP ADD CDENCARGO VARCHAR2(02) NULL