Dropping Tables

To drop a table, use either the SQL Developer navigation frame and Drop tool, or the DDL statement DROP TABLE.

Caution: Do not drop any of the tables that you created in "Creating Tables"—you need them for later tutorials. If you want to practice dropping tables, create simple ones and then drop them.

To drop a table using the Drop tool:

On the Connections tab, expand hr_conn.

Under the hr_conn icon, a list of schema object types appears.
Expand Tables.

A list of tables appears.
Right-click the name of the table to drop.

A list of choices appears.
Click Table.

A list of choices appears.
Click Drop.

The Drop window opens.
Click Apply.

The Confirmation window opens.
Click OK.

Dropping Tables

Related Topics