next up previous contents index
Next: Summary Up: Basic SQL Commands Previous: Sorting Data with ORDER

  
Destroying Tables

This chapter would not be complete without showing you how to remove tables. This task is accomplished using the DROP TABLE command. For example, the command DROP TABLE friend will remove the friend table. Both the table structure and the data contained in the table will be erased. We will use the friend table in the next chapter, so you should not remove the table at this time. Remember--to remove only the data in the table without removing the table structure itself, use DELETE.  


Bruce Momjian
2001-05-09