Deleting Tables

Deleting tables is the easiest database function of all of the functions we have covered. Simply use the DROP TABLE command, and the table-as well as all of the data in it-is gone. Use this command with caution!

Let's say we have sold a portion of the company and we no longer sell products. We want to get rid of our product table. We still want to keep the vendor table, however, for our birthday-card list. To get rid of the products table, we simply have to do this:

DROP TABLE products;

The table is gone, and all of its data is gone as well.