Changes

Updating and Deleting MySQL Tables

274 bytes added, 19:44, 2 October 2007
Changing The Data Type of a Column
<pre>
ALTER TABLE products MODIFY prod_description CHAR(20);
</pre>
 
== Deleting a Database Table ==
 
A table may be deleted from a database using the ''DROP TABLE'' statement. All that is required with this statement is the name of the table to be deleted. The deletion is permanent and cannot be undone:
 
<pre>
DROP TABLE customers;
</pre>