1.查出有哪些约束

SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE,STATUS FROM USER_CONSTRAINTS
WHERE TABLE_NAME ='D_DRUG_DICTIONARY';

Oracle 删除唯一约束_do better myself

 

 

2.删除 唯一约束

ALTER TABLE D_DRUG_DICTIONARY DROP CONSTRAINT UN_DRUG_DIC_UID;

Oracle 删除唯一约束_do better myself_02