You can drop a secondary index anytime and create it with a different definition. We cannot change the column set of a primary index. However, you can change it from NUPI to UPI, for example: ALTER TABLE Customer MODIFY UNIQUE PRIMARY INDEX (>NUPI columns>)