---
title: TRUNCATE Statements
description: This topic describes how you use TRUNCATE statements to delete all
  the data in a collection in Capella Analytics.
pubDate: 2026-08-17T09:53:44.266Z
antora:
  editUrl: https://github.com/couchbaselabs/docs-columnar/edit/main/modules/sqlpp/pages/5_dml_truncate.adoc
  xref: xref:analytics:sqlpp:5_dml_truncate.adoc[]
---

[Consult the llms.txt file for a full list of contents](/llms.txt)
[View original HTML](/analytics/sqlpp/5_dml_truncate.html)

# TRUNCATE Statements

> This topic describes how you use TRUNCATE statements to delete all the data in a collection in Capella Analytics. 

The TRUNCATE statement is used to immediately remove all data from a collection in Capella Analytics. Upon execution, all associated data files are deleted from storage, and the space is instantly reclaimed.

This differs from the DELETE statement, which marks records for deletion and only reclaims space during a later compaction process.

TRUNCATE is supported only for standalone and remote collections and is not available for external collections or views.

When executed on a remote collection with a connected link, the link is temporarily disconnected, the TRUNCATE operation is performed, and the link is reconnected.

## [](#syntax)Syntax

**Truncate EBNF** 

```EBNF
Truncate ::=  "TRUNCATE" "ANALYTICS"? "COLLECTION" QualifiedName ("IF" "EXISTS")?
```

**Truncate Diagram** 

![TRUNCATE](_images/Truncate.png) 

The first `QualifiedName` resolves to a remote collection, a standalone collection or a synonym.

## [](#examples)Examples

This example deletes all the data in a standalone collection named `Orders`:

```SQL++
  TRUNCATE COLLECTION database_name.scope_name.Orders;
```