To drop an index using T-SQL, you need to use the DROP INDEX statement, which has the following syntax: DROP INDEX index_name ON table_or_view_name [;] The index_name is the name of the index you ...

DROP INDEX idx_a, idx_b, idx_c ON table_name Now that the stupid syntax is out of the way! An index in SQL is like the index in a book - It provides an easier way to find specific data.

If you drop a table with indexed columns, all the indexes are automatically dropped. If you drop a composite index, the index is dropped for all the columns that are named in that index. You cannot ...