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.
 

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, select phpMyAdmin. 
      Name of the article
  3. From the list of databases, select the database that contains the table you wish to rename.

Note: If you are unsure whether the account uses the Legacy or Bluerock interface, please see Rock vs. Legacy to determine which steps to follow.

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.