SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

image.png

Hi team, I want to truncate all tables from all databases. But I have this error using command
```TRUNCATE ALL TABLES FROM signoz_metrics;```
Appreciate your help

As context, we recently migrated to 0.88 but could not migrate successfully the old data (only the alerts and dashboards) so to clean up and don't store old not used info , I want to truncate all tables in clickhouse

We're on clickhouse 24.1.2. There's a slightly different TRUNCATE command.

clickhouse does not have docs per version, I seen to only find the latest, can you share cmd for 24.1.2?

```TRUNCATE TABLE signoz_metrics.&lt;insert table name&gt; ON CLUSTER cluster;```

This might not be the recommended way to do it but it will work! (I'm sure there is some command hidden somewhere)