SQL DROP INDEX, DROP TABLE, and DROP DATABASE

Indexes, tables, and databases can easily be deleted/removed with the DROP statement.

The DROP INDEX Statement

The DROP INDEX statement is used to delete an index in a table.

DROP INDEX index_name ON table_name

DROP INDEX table_name.index_name

DROP INDEX index_name

ALTER TABLE table_name DROP INDEX index_name

The DROP TABLE statement is used to delete a table.

DROP TABLE table_name

The DROP DATABASE statement is used to delete a database.

DROP DATABASE database_name

What if we only want to delete the data inside the table, and not the table itself?

Then, use the TRUNCATE TABLE statement:

TRUNCATE TABLE table_name