ALTER TABLE SUBSCOMPMENU ADD CONSTRAINT PK_SUBSCOMPMENU PRIMARY KEY (NRORG, NRSUBSCOMPMENU)
/
ALTER TABLE SUBSCOMPMENU ADD CONSTRAINT CKC_IDSITUACAO_SUBSCOMPMENU CHECK (IDSITUACAO IN ('A','P','E','R'))
/
ALTER TABLE SUBSCOMPMENU ADD CONSTRAINT CKC_IDATIVO_SUBSCOMPMENU CHECK (IDATIVO IN ('S', 'N'))