ALTER TABLE QUESTIONARIO DROP CONSTRAINT CKC_NMAPLICATIVO_QUESTIONARIO
/
ALTER TABLE QUESTIONARIO DROP COLUMN NMAPLICATIVO
/
ALTER TABLE QUESTIONARIO ADD IDAPLICATIVO VARCHAR2(30) NOT NULL
/
ALTER TABLE  QUESTIONARIO ADD CONSTRAINT CKC_IDAPLICATIVO_QUESTIONARIO CHECK (IDAPLICATIVO IN ('MYMENU','MYQUEST'))
/
ALTER TABLE RESPOSTAPESQ DROP CONSTRAINT CKC_NMAPLICATIVO_RESPOSTAPESQ
/
ALTER TABLE RESPOSTAPESQ DROP COLUMN NMAPLICATIVO
/
ALTER TABLE RESPOSTAPESQ ADD IDAPLICATIVO VARCHAR2(30) NOT NULL
/
ALTER TABLE RESPOSTAPESQ ADD CONSTRAINT CKC_IDAPLICATIVO_RESPOSTAPESQ CHECK (IDAPLICATIVO IN ('MYMENU','MYQUEST'))