ALTER TABLE CONSUMOREAL ADD CONSTRAINT CKC_IDATIVO_CONSUMOREAL CHECK (IDATIVO IN ('S', 'N'))
/
ALTER TABLE CONSUMOREAL ADD CONSTRAINT PK_CONSUMOREAL PRIMARY KEY (CDFILIAL, DTCONSUMO, CDPRODUTO)