SQL DROP INDEX, DROP TABLE, and DROP DATABASE

SQL DROP INDEX, DROP TABLE, and DROP DATABASE

The DROP INDEX Statement

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

DROP INDEX Syntax for MySQL:

ALTER TABLE table_name DROP INDEX index_name

DROP INDEX Syntax for MS Access:

DROP INDEX index_name ON table_name

DROP INDEX Syntax for MS SQL Server:

DROP INDEX table_name.index_name

DROP INDEX Syntax for DB2/Oracle:

DROP INDEX index_name

---

The DROP TABLE Statement

The DROP TABLE statement is used to delete a table.

DROP TABLE table_name

---

The DROP DATABASE Statement

The DROP DATABASE statement is used to delete a database.

DROP DATABASE database_name

---

The TRUNCATE TABLE Statement

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