Removing Tables

You can discard a table if you no longer find it useful. The DROP TABLE statement removes the definition of the table from the database.

Deleting all of the records in a table is different from DROP TABLE. After deleting all the records, the column and constraint information still remains. But DROP TABLE results in the removal of the table definition along with the rows.

In Oracle Database XE, you can remove a table in either of the following ways:

* Select Object Browser > Browse > Tables. Click the table name, and then click DROP.
* Select SQL > SQL commands > Enter command. Type the SQL statement, and then click Run.