select * from all_constraints where table_name = 'TABLENAME';
select * from User_Cons_Columns where table_name = 'TABLENAME';
alter table TABLENAMEdrop constraint SYS_C006694;--删除约束
select * from all_constraints where table_name = 'TABLENAME';
select * from User_Cons_Columns where table_name = 'TABLENAME';
alter table TABLENAMEdrop constraint SYS_C006694;--删除约束