create table drop_idx_tab(
StudentID integer, StudentNames varchar(255), Age integer);
insert into drop_idx_tab(StudentID, StudentNames, Age)
values((1, "Alex", 18),
(2, "Akash", 27),
(3, "Ramisha", 21));
create index idx_unique
on drop_idx_tab (StudentID);
alter table drop_idx_tab
drop index idx_unique;