On this page
Renaming database tables with phpMyAdmin
Learn how to rename a table in a database using phpMyAdmin in cPanel, keeping all of its columns and data.
You can rename a table in phpMyAdmin at any time - for example to give it a clearer name, or to match a change in your application. The table keeps all of its columns and data; only the name changes. This guide shows how.
Before you start
Open phpMyAdmin from the Databases section of cPanel, click your database, then click the table you want to rename. New to phpMyAdmin? See Becoming familiar with databases in phpMyAdmin.
Rename a table
-
With the table open, click the Operations tab.
-
In the Table options box, find the Rename table to field and type the new name.
-
Click the Go button at the bottom of the Table options box.
phpMyAdmin renames the table and confirms the change. The table then appears under its new name in the left-hand panel, with all of its data intact.
If a website or application connects to this table, remember to update its code or configuration to use the new name - otherwise it will no longer be able to find the table.
To make a duplicate of a table under a different name instead, see Copying a database table with phpMyAdmin.
If you need a hand, our support team is available 24/7 - just open a support ticket.