Knowledge Base
Up to 70% off on  WordPress  hosting for WordPress Websites and Stores!

How to Rename Database Tables in phpMyAdmin

Did you find this article helpful?
Copy Link

* Your feedback is too short

This article will show you how to rename a database table in phpMyAdmin.

Access The Database

These steps explain how to access phpMyAdmin.

  1. Log in to your Bluehost Account Manager.
  2. Select the Hosting tab from the left navigation menu.
  3. Search for the Quick Links tile and click the CPANEL button.
    Cpanel button under Quick Links 
  4. Go to Databases, then click phpMyAdmin.
    phpMyAdmin icon under Databases

Running The Alter Command

Once you have the correct database selected, these steps will explain how to run an alter command to rename your table.

  1. Click the SQL tab at the top.
  2. In the text box, enter the following command:
    ALTER TABLE exampletable RENAME TO new_table_name;
  3. Replace exampletable with your table's name and replace new_table_name with the new name for your table.
  4. Click the Go button.

The database table should now have a new name.

If you need further assistance, feel free to contact us via Chat or Phone:

  • Chat Support - While on our website, you should see a CHAT bubble in the bottom right-hand corner of the page. Click anywhere on the bubble to begin a chat session.
  • Phone Support -
    • US: 888-401-4678
    • International: +1 801-765-9400

You may also refer to our Knowledge Base articles to help answer common questions and guide you through various setup, configuration, and troubleshooting steps.

Did you find this article helpful?
Copy Link

* Your feedback is too short