Oracle 删除唯一约束
1.查出有哪些约束
SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM USER_CONSTRAINTS WHERE TABLE_NAME ='D_DRUG_DICTIONARY';
2.删除 唯一约束
ALTER TABLE D_DRUG_DICTIONARY DROP CONSTRAINT UN_DRUG_DIC_UID;
本文来自博客园,作者:VipSoft 转载请注明原文链接:https://www.cnblogs.com/vipsoft/p/12940716.html