Easy Tutorial
❮ Sql Between Sql Wildcards ❯

SQL Drop Index, Drop Table, and Drop Database


By using the DROP statement, you can easily delete indexes, tables, and databases.


DROP INDEX Statement

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

DROP INDEX Syntax for MS Access:

DROP INDEX Syntax for MS SQL Server:

DROP INDEX Syntax for DB2/Oracle:

DROP INDEX Syntax for MySQL:


DROP TABLE Statement

The DROP TABLE statement is used to delete a table.


DROP DATABASE Statement

The DROP DATABASE statement is used to delete a database.


TRUNCATE TABLE Statement

If we only need to delete the data inside the table but not the table itself, what should we do?

Use the TRUNCATE TABLE statement:

❮ Sql Between Sql Wildcards ❯