34,333
edits
Changes
→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>