> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# TRUNCATE
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `TRUNCATE` statement removes all rows from a table. At a high level, it works by dropping the table and recreating a new table with the same name.
The `TRUNCATE` statement performs a schema change. For more information about how online schema changes work in CockroachDB, see Online Schema Changes.
`TRUNCATE` is a schema change, and as such is not transactional. For more information about how schema changes work, see Online Schema Changes.
## Synopsis
## Required privileges
The user must have the `DROP` privilege on the table.
## Parameters
| Parameter | Description |
| ------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `table\_name` | The name of the table to truncate. |
| `CASCADE` | Truncate all tables with Foreign Key dependencies on the table being truncated. `CASCADE` does not list dependent tables it truncates, so should be used cautiously. |
| `RESTRICT` | *(Default)* Do not truncate the table if any other tables have Foreign Key dependencies on it. |
## Viewing schema changes
This schema change statement is registered as a job. You can view long-running jobs with `SHOW JOBS`.
## Examples
### Truncate a table (no foreign key dependencies)
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM t1;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+------+
| id | name |
+----+------+
| 1 | foo |
| 2 | bar |
+----+------+
(2 rows)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> TRUNCATE t1;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM t1;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+------+
| id | name |
+----+------+
+----+------+
(0 rows)
```
### Truncate a table and dependent tables
In these examples, the `orders` table has a Foreign Key relationship to the `customers` table. Therefore, it's only possible to truncate the `customers` table while simultaneously truncating the dependent `orders` table, either using `CASCADE` or explicitly.
#### Truncate dependent tables using `CASCADE`
`CASCADE` truncates *all* dependent tables without listing them, which can lead to inadvertent and difficult-to-recover losses. To avoid potential harm, we recommend truncating tables explicitly in most cases. See [Truncate Dependent Tables Explicitly](#truncate-dependent-tables-explicitly) for more details.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> TRUNCATE customers;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
pq: "customers" is referenced by foreign key from table "orders"
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> TRUNCATE customers CASCADE;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM customers;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+-------+
| id | email |
+----+-------+
+----+-------+
(0 rows)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM orders;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+----------+------------+
| id | customer | orderTotal |
+----+----------+------------+
+----+----------+------------+
(0 rows)
```
#### Truncate dependent tables explicitly
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> TRUNCATE customers, orders;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM customers;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+-------+
| id | email |
+----+-------+
+----+-------+
(0 rows)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT * FROM orders;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
+----+----------+------------+
| id | customer | orderTotal |
+----+----------+------------+
+----+----------+------------+
(0 rows)
```
## See also
* `DELETE`
* `SHOW JOBS`
* Foreign Key constraint
* Online Schema Changes