next up previous contents
Next: Stopping the database Up: Oracle Basics Previous: Creating and Querying a   Contents

Destroying Schema Objects

We can easily destroy old or unneeded objects as need be using the DROP statements.

SQL> drop view cell_view;

View dropped.

SQL> select * from address_book;

        ID NAME                           HOME_NUM     CELL_NUM
---------- ------------------------------ ------------ ------------
         1 Ben Rockwood                   510-555-1234 650-555-2345
Menlo Park, CA

         2 Tamarah Rockwood               510-555-4443
Menlo Park, CA

         3 Nova Rockwood
Menlo Park, CA

SQL> drop table address_book;

Table dropped.