重新命名和删除约束

1.重新命名约束
alter table scott.emp
rename constraint pk_emp
to emp_empno_pk;
2.查询一下
select constraint_name,table_name,constraint_type,status,deferrable,
deferred,validated
from dba_constraint
where owner='SCOTT';
3.删除约束
alter table scott.event
drop constraint event_evid_pk;
4.查询一下
select constraint_name,table_name,constraint_type,status,deferrable,deferred,validated from dba_constraints
where owner='SCOTT';