DROP

Use the DROP statement to remove a table or index from the database. Its syntax is:

  DROP {TABLE table | INDEX index ON table}

The parts of the DROP statement have the following meanings:

Part Meaning

table The table to be removed

index The index to be removed