ALTER TABLE PARAVEND DROP CONSTRAINT CKC_IDBLOQTROCSAT_PARAVEND
/
ALTER TABLE PARAVEND DROP COLUMN IDBLOQTROCSAT
/
ALTER TABLE PARAVEND ADD IDBLOQTROCSAT VARCHAR2(1) DEFAULT 'N' NOT NULL
/
ALTER TABLE PARAVEND ADD CONSTRAINT CKC_IDBLOQTROCSAT_PARAVEND CHECK (IDBLOQTROCSAT IN ('S','N'))