Renaming database tables with phpMyAdmin Print

  • 119

The aim of this article is to assist you how to rename database tables with phpMyAdmin. We will assume that you are already signed in to phpMyAdmin. For this article, we will use a database with one table for an example.

Let's learn a way to rename database tables. The left side of the main screen of phpMyAdmin is where you will see 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 begin, pick the database table you like to rename in the list on the left hand side window. Choose the table by clicking on it. The window on the right hand side will open up with the information about the table you have chosen. Then, at the top of the right hand screen, click on the Operations button. This will 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 to with an empty box. Type in the new name for your table in this box. Once 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 different name.

This is the end of this article. You already know a way to rename database tables using phpMyAdmin.


Was this answer helpful?

« Back