To rename a table in ClickHouse, use the RENAME TABLE statement.

This example renames the table my_table to my_renamed_table:

RENAME TABLE my_table TO my_renamed_table;

Get started with DB Pilot

DB Pilot is a Database GUI client and SQL editor for PostgreSQL, MySQL, SQLite, DuckDB & more.