Introduction to Databases for the Web: Pt. 1 - Page 11
August 16, 1998
Deleting Databases and Tables
It is also simple to delete tables and databases using GUI tools or SQL. In the case of a GUI, you will simply select a table or database from your main menu and delete it as you would a file in a file system manager.
In SQL, you would simply use the
In the case of deleting a whole database, you
will use the
The following example would delete the
In the case of a table, you use the DROP command:
Essentially when you use delete and drop, you are modifying the database management system's data dictionary. It shouldn't have to be said, but I will say it...BE CAREFUL WHEN DELETING OR DROPPING!
Altering a Table
Finally, you should know that it is possible to "alter"
a table after it has been created using either a standard GUI tool or
by using the
such as the following case in which
we alter the table named