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

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.

renaming

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.

execution-message

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