SQLite - How to rename a table in SQLite3?

Rename a table SQLite 3

Using SQL query:

ALTER TABLE old_table_name RENAME TO new_table_name;

For example, rename the table orders to bookings

ALTER TABLE orders RENAME TO bookings;

Using TablePlus GUI Tool

In TablePlus, you can be able to rename a table from the structure view:

Switch to database structure tab at the bottom, then find the name edit the name as you like

Remember to commit the changes to the database using cmd + S

---

New to TablePlus? It’s a GUI client for multiple relational databases. It’s native, beautiful, and available for free.

Check it out: Download TablePlus here.