How to Rename the database tables using phpMyAdmin?

Rename database tables using phpMyAdmin

Rename the database tables using phpMyAdmin

The information in the database is stored in tables. A database consists of one or more tables and each table is made up of rows and columns. Each row in a relational database is identified by a primary key and the columns hold a specific type of data such as numeric or textual data. The database tables can be renamed using phpMyAdmin in cPanel by following the below steps

Step 1: Login to cPanel

Step 2: Go to the Databases section in cPanel dashboard

Step 3: Select the option phpMyAdmin under the section Databases

Step 4: Select the Database in the left pane of the page

Step 5: In the database, select the table from the list which is to be renamed

Step 6: Select the option Operations from the list of menus at the top of the page

Step 7: In the option Operations, go to the Table Options

Step 8: Enter the name to be renamed in the respective field under the option “Rename Table to” and then click the button “Go”

Step 9: A successful message of table renamed will be displayed

Step 1 Login to cPanel.

Step 2 Go to Database Section.

Go to Database section

Step 3 Select phpMyAdmin.

select phpMyAdmin

Step 4 Select the Database in the Left Pane.

Select the Database in left pane.

Step 5 Select the Table in the list.

Select the table in the list.

Step 6 Select the Operation menu at the top of the page.

Select the operation menu at the top

Step 7 Go to the Table options.

Go to table option.

Step 8 Fill the Textbox with the details and click Go button.

Fill the name and click Go button.

Step 9 Success message will be displayed.

Success Message will be displayed.