# 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;
```