ALTER TABLE LOJA ADD IDIMPRVIACONSTEF VARCHAR2(1) DEFAULT 'N'
/
ALTER TABLE LOJA ADD CONSTRAINT CKC_IDIMPRVIACONSTEF CHECK (IDIMPRVIACONSTEF IN ('S','N'))