How deeply does ScyllaDB in Action cover truncate?

Defines the command, contrasts it with DROP TABLE, and demonstrates the resulting empty table.

Truncate

A TRUNCATE statement removes every row from a table while leaving the table structure intact.

TRUNCATE removes every row from a Scylla table while keeping the table itself available for future inserts and updates. section 6.2.4

Clear a test table

Run `TRUNCATE article_summaries_by_date;`. A subsequent `SELECT *` returns zero rows, but the table remains usable. Unlike `DROP TABLE`, TRUNCATE does not remove the table structure. section 6.2.4

cqlsh: reviews> TRUNCATE article_summaries_by_date;

Run the cqlsh command that clears all rows from the review-summary table. section 6.2.4

How ScyllaDB in Action covers it

liveBook manning.com

Read ScyllaDB in Action on liveBook Get the book at manning.com

Related concepts

drop table statementcontrasts with · A DROP TABLE statement is an SQL data-definition statement that removes an existing table and its associated data and definition from a database.
database pageuses · A database page is a fixed-size unit of physical storage containing rows or portions of rows from database objects.
where clausecontrasts with · A WHERE clause is a query-language clause that restricts returned or affected records to those satisfying a specified predicate.
redundancyaddresses · Redundancy is the presence of duplicate or overlapping information, components, or resources, whether intentional or unnecessary.
deletionalternative to · Deletion is an operation that removes an item, association, or resource from a collection or system, or requests or marks it for removal.
SQLkind of · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.

This explainer was generated by Manning's knowledge graph from the text of ScyllaDB in Action. The section links point to the parts of the book it draws on.