ALTER TABLE RATEIOPADRAOFIS ADD CONSTRAINT PK_RATEIOPADRAOFIS  PRIMARY KEY (CDRATEIOPADRAO)
/

ALTER TABLE RATEIOPADRAOFIS MODIFY IDRATEIOPADRAO VARCHAR2(03) DEFAULT 'SME' NOT NULL
/

ALTER TABLE RATFISTPOPERAC MODIFY IDENTRSAIDOP VARCHAR2(01) DEFAULT 'S' NOT NULL
/

ALTER TABLE RATFISTPOPERAC ADD CONSTRAINT CKC_IDENTRSAIDOP_RATFISTPOPERA CHECK (IDENTRSAIDOP IN ('E','S'))
/ 