How to Drop an Index in MS-SQL

To drop an index in MS-SQL Server you need to know the index name, for example emp_ix1:

drop index emp_ix1 on employee;

IN THIS PAGE