---
schema_version: "1"
id: 4114efd6621e5ec6a69bfaefa26a2f833e850d01f64aa924a1503ed4e3c56d88
title: TRUNCATE
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/truncate.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/truncate.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 1ea6e58268d8b9dcf651293341cf910dc8336be9c2d9b929fbf29bea934e96a5
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# TRUNCATE

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Empty a table.

## Syntax

```sql
TRUNCATE [ TABLE ] <name>
```

## Description

`TRUNCATE` removes all rows from a table. It has the same effect as an
unqualified `DELETE` on the target table. It is just used as a
convenience statement.

## Parameters

- `<name>`

  - : The name (optionally schema-qualified) of a table to truncate.

## Examples

Truncate the table `bigtable`:

```sql
    TRUNCATE bigtable;
```