Disabling Enabled Constraints
The subsequent statements are examples of statements which disable enabled integrity constraints:
ALTER TABLE dept
DISABLE CONSTRAINT dname_ukey;
ALTER TABLE dept
DISABLE PRIMARY KEY,
DISABLE UNIQUE (dname, loc);
The reversal of enable is disabling. These two statements disable the enabled constraints. As like ENABLE, this does not perform any checking although disabling.