SQL to drop an index on table.

SQLServer:
DROP INDEX address.ix_address_loc;

Syntax for Microsoft SQLJet (and Microsoft Access):
DROP INDEX index_name ON table_name

Syntax for IBM DB2 and Oracle:
DROP INDEX index_name

Syntax for MySQL:
ALTER TABLE table_name DROP INDEX index_name