Deleting a table

By Joe Gardiner Thursday, 25th March 2010

This guide will presume you have already created a table in your CatN vCluster database, or have existing tables created by a CMS install or something similar.

For a guide to manually creating a database table, have a look here.

[youtube video="_nvOSKMxe3g" align="left" author="by Joe Gardiner - CatN" bgcolor="#000000" color="#336699" hd="true" height="300" title="Deleting a table" width="500"]

Log in to you database phpMyadmin dashboard. For a guide on how to do this, click here.

Have a look in the left hand sidebar, and presuming you created a table named TEST in a previous guide, you should see this table displayed.

Click the TEST table name, or the name of any other table you want to delete, and you’ll be directed to the table management screen, showing the fields contained within that table.

Now, if you have a look at the top navigation bar, the last tab is named “Drop”. You can click this now to be directed to a confirmation dialogue. Warning, if you drop the table, all fields and records will be deleted permanently. Make sure you are doing this to a test table, or a table you are 100% certain about deleting.

Now, if you look at the left sidebar again, your table will now be removed, and, if you deleted your first TEST table, the sidebar should now be empty, apart from the database name.

Posted in Guides, phpMyAdmin | No Comments »