修改oracle数据库约束

增加约束
ALTER TABLE tableName
ADD [CONSTRAINT constraint] 
type (column);
//name变为唯一性约束
alter table insert_test2
add constraint test_name_uk
unique(name)
//删除约束
alter table insert_test2
drop constraint test_name_uk
//使约束失效disable
alter table insert_test2
disable constraint test_name_uk
//使约束生效enable
alter table insert_test2
enable constraint test_name_uk
删除表：
DROP TABLE table 
[CASCADE CONSTRAINTS];