Rename Tables

Renaming tables without using SQL commands.

Select Database Connection

  • From DB Explorer choose the database connection where the table is located.
  • From the list of available databases, select the desired one.

Choose the Table to Rename

  • In the database tables list, locate the table you wish to rename.
  • Right-click on the table name and select Rename Table.
Rename table option
Access the Rename Table option from the context menu

Enter the New Table Name

  • An input box will appear at the top of the window, prompting you with “Enter the name of the table.”
  • Delete the current name, type the new name for the table, then press Enter to confirm or Escape to cancel.
Rename table dialog
Enter the new name for your table in the input box

Confirm Successful Renaming

  • After pressing Enter, a message will display in the DB Code Panel at the bottom of the window: “Success, 0 rows affected,” confirming the table has been renamed successfully.
  • The DB Explorer will also refresh the connection to reflect the changes.
Success message after renaming
A confirmation message appears when the table is successfully renamed

This process ensures a quick and straightforward table renaming in your database, with clear feedback at each step.