How to Rename Database Tables in phpMyAdmin | Bluehost Support
  1. bluehost knowledge base

How to Rename Database Tables in phpMyAdmin

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



Access The Database

These steps explain how to access phpMyAdmin.

Note: Legacy accounts will feature a horizontal navigation bar at the top of the screen, while Bluerock account users will see a vertical navigation menu on the left-hand side of the screen. If you are still unsure what interface your account uses, please see Bluerock vs. Legacy to determine which step to follow.

Bluerock

  1. Log in to your Bluehost control panel.
  2. Click the Advanced tab from the side navigation menu to the left.
  3. Under the Database section, select phpMyAdmin.
    Name of the article
  4. From the list of databases, select the database that contains the table you wish to rename.

Legacy

  1. Log in to your Bluehost control panel.
  2. Look for the Database tools section and select phpMyAdmin. 
      Name of the article
  3. From the list of databases, select the database that contains the table you wish to rename.

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 - From our home page, click the Contact option in the top right-hand corner, then click Chat Now.
  • 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.