Renaming database tables with phpMyAdmin

The purpose of this tutorial is to teach you how to rename database tables with phpMyAdmin. We will assume that you are already logged in to phpMyAdmin. For this tutorial, we will use a database with one table for an example.

The left side of the main screen of phpMyAdmin is where you will find your database listed with the table listed below the database name. The right side, a big white screen is where the actions take place.

To start, select the database table you wish to rename in the list on the left hand side window. Select the table by clicking on it and the right window will open up with the details of the table. Now, at the top of the right hand screen, click on the operations button to open a list of actions you can perform on the table you have selected.

Scroll down to the box titled "Table Options". The first line is rename table with an empty box, enter the new name for your table in this box. When you are done, click on the go button in the lower right corner. This will open the confirmation window which shows that the table has been renamed. If you look in the panel on the left hand side, the table you selected is now showing the new name.

For additional assistance, contact us by submitting a support ticket.

Was this answer helpful?

Add to Favourites Add to Favourites

Print this Article Print this Article

Quick Navigation

Client Login:



Remember Me