How to Drop a Table in ClickHouse

To delete a table in ClickHouse, use the DROP TABLE statement.

This example deletes the table my_table:

DROP TABLE my_table

Get started with DB Pilot

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