> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference and syntax for the TRUNCATE TABLE command.

# TRUNCATE TABLE

Removes all rows from a table.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
TRUNCATE TABLE <table_name> 
```

## Parameters

| Parameter      | Description                            |
| :------------- | :------------------------------------- |
| `<table_name>` | The name of the table to be truncated. |

### Example

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
TRUNCATE TABLE product;
```

Table before

```
product
+------------+--------+
| name       | price  |
+---------------------+
| wand       |    125 |
| broomstick |    270 |
| bludger    |      0 |
| robe       |     80 |
| cauldron   |     25 |
| quaffle    |      0 |
+------------+--------+
```

Table after

```
product
+------------+--------+
| name       | price  |
+---------------------+
```