重新命名和删除约束

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&＃61;&＃39;SCOTT&＃39;;

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&＃61;&＃39;SCOTT&＃39;;