ALTER TABLE PEDCOLGERAL DROP CONSTRAINT CKC_IDSITUPEDCOLETA
/
ALTER TABLE PEDCOLGERAL ADD CONSTRAINT CKC_IDSITUPEDCOLETA CHECK (IDSITUPEDCOLETA IN ('N','A','R','I','T', 'C'))
/
ALTER TABLE PEDCOLETA DROP CONSTRAINT CKC_IDSITUPEDCOL
/
ALTER TABLE PEDCOLETA ADD CONSTRAINT CKC_IDSITUPEDCOL CHECK (IDSITUPEDCOL IS NULL OR (IDSITUPEDCOL IN ('N','A','R','I','T', 'C')))
/
ALTER TABLE COMENTPEDCOL DROP CONSTRAINT FKCMP00155PEDCOLGERAL
/
ALTER TABLE COMENTPEDCOL
	ADD CONSTRAINT FKCMP00155PEDCOLGERAL FOREIGN KEY (CDFILIAL, NRPEDIDOCOL)
		REFERENCES PEDCOLGERAL (CDFILIAL, NRPEDIDOCOL) ON DELETE CASCADE
/ 