ALTER TABLE employees --alter可以跟多个enable|disable约束的子句,必须同须符合,才能开启约束
ENABLE NOVALIDATE PRIMARY KEY
ENABLE NOVALIDATE CONSTRAINT emp_last_name_nn;
ALTER TABLE locations --locations是dept的主表,dept为子表,有modify primary key disable cascade,就会同时禁用外键约束
MODIFY PRIMARY KEY DISABLE CASCADE;
alter table tt drop(b,c) --alter drop删除多列