If you want to Create an cluster index on table then there should not be any index on that table. So first need to remove the old index and update the index. To do this we may write the below command to update the index by dropping the old one and creating the new.
UNIQUE CLUSTERED INDEX i_IndexA
(DROP_EXISTING = ON);
- i_IndexA = name of the Index
- id= column name of the table
- Drop existing=on means that If any old index is existing on the table then it should be removed.