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.



Perl Database Programming
Perl Database Programming
ISBN: 0764549561
EAN: 2147483647
Year: 2001
Pages: 175

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net