SQL DROP INDEX, DROP TABLE, DROP DATABASE

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

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

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