菲力貓的程式設計

錯誤訊息 :
ORA-02429: 無法捨棄用來強制實現唯一/主索引鍵的索引
ORA-02429: cannot drop index used for enforcement of unique/primary key


檢查要刪除的Index是否有相依的Constraint,如果有... 先刪除Constraint,再刪除Index
alter table [Table Name] drop constraint [Constraint];
DROP index [Index Name];