Hi team, I want to truncate all tables from all da...
# supporte
Efrain Sotelo Ferry
08/04/2025, 9:32 AMHi team, I want to truncate all tables from all databases. But I have this error using command
Copy code
TRUNCATE ALL TABLES FROM signoz_metrics;Efrain Sotelo Ferry
08/04/2025, 9:33 AMAs 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
v
Vibhu Pandey
08/04/2025, 9:45 AMWe're on clickhouse 24.1.2. There's a slightly different TRUNCATE command.
e
Efrain Sotelo Ferry
08/04/2025, 9:49 AMclickhouse does not have docs per version, I seen to only find the latest, can you share cmd for 24.1.2?
v
Vibhu Pandey
08/04/2025, 10:10 AM Copy code
TRUNCATE TABLE signoz_metrics.<insert table name> ON CLUSTER cluster;Vibhu Pandey
08/04/2025, 10:10 AMYou can run this for all tables
Vibhu Pandey
08/04/2025, 10:11 AM Copy code
SHOW TABLES FROM signoz_metrics;Vibhu Pandey
08/04/2025, 10:11 AMThis might not be the recommended way to do it but it will work! (I'm sure there is some command hidden somewhere)
4 Views