
# 删除ClickHouse表
本章节介绍删除ClickHouse表样例代码。
以下代码片段在com.huawei.clickhouse.examples包的"Demo"类的dropTable方法中。
用于删除在[创建ClickHouse表](https://support.huaweicloud.com/devg3-mrs/mrs_07_460015.html)中创建的副本表和分布式表。
```
private void dropTable(String databaseName, String tableName, String clusterName) throws Exception {
    String dropLocalTableSql = "drop table if exists " + databaseName + "." + tableName + " on cluster " + clusterName;
    String dropDisTableSql = "drop table if exists " + databaseName + "." + tableName + "_all" + " on cluster " + clusterName;
    ArrayList<String> sqlList = new ArrayList<String>();
    sqlList.add(dropLocalTableSql);
    sqlList.add(dropDisTableSql);
    util.exeSql(sqlList);
}
```
