Knowledgebase

How To Delete Tables On phpMyAdmin

1. Log in to your cPanel or Plesk.

2. Navigate to your control panel and click the phpMyAdmin icon.

3. In the phpMyAdmin homepage, select the database you wish to work on.

Select Database

4. A list of tables will appear in the left column and the wider right column.

phpMyAdmin - List of Tables

5. Put a checkmark on the table(s) you wish to drop (permanently delete).

6. Navigate to the dropdown box at the bottom that initially says "With selected."

7. Select Drop from the list if you wish the table completely gone. If you want to clear the data in the table and keep its structure, select Empty.

With Select - Drop

8. It will ask you if you really want to drop the table(s). Check to make sure you selected the tables you really want to delete.

9. Click on Yes to delete the table.

 

 

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL injection

SQL injection is an attack where malicious code is passed to an SQL Server for execution. The attack can result in unauthorized access to confidential data or the destruction of critical data....

MySQL Database Limit

There is no limit for the size of databases. MySQL is only limited to the size of your cPanel's disk space. As long as there is still some free space in your cpanel disk, you are good to go.

MySQL Variable Types

MySQL database has three (3) main data types: text, numbers and dates/times. Text Types CHAR( ) A fixed section from 0 to 255 characters long. VARCHAR( ) A variable section from 0...

cPanel MySQL Database Wizard

This instructions guides you through the setup of a MySQL® database, user accounts, and user privileges. We recommend that you use this wizard to create your first database and user. To create...

phpMyAdmin Glossary

phpMyAdmin is a free open source tool written in PHP language. This tool handles the administration of MySQL and MSSQL over the web, performing various tasks such as creating, modifying or deleting...