From http://www.w3schools.com (Copyright Refsnes Data)

SQL DROP INDEX, DROP TABLE, and DROP DATABASE

previous next

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 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

DROP INDEX Syntax for MySQL:

ALTER TABLE table_name 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


previous next

From http://www.w3schools.com (Copyright Refsnes Data)