How do you create and drop an index in SQL?

Creating an Index:

CREATE INDEX idx_index_name ON table_name(column_name);

Dropping an Index:

DROP INDEX idx_index_name ON table_name;

In SQL Server, dropping an index:

DROP INDEX idx_index_name; -- No need to specify table name.