Learning Apache Cassandra - Second Edition

Deleting table data (TRUNCATE)

There might be situations where data within a table gets corrupted. In such situations, you might want to delete the entirety of the data within a table without deleting the schema and then restore from a previous backup. To perform this, CQL protocol provides the TRUNCATE command. To delete the data from a table, such as the users table, you will have to execute either of the following statements:

TRUNCATE "users"; 

You could also use the following:

TRUNCATE TABLE "users";