TRUNCATE TABLE

Removes all rows from a table.

Syntax

TRUNCATE TABLE <table_name>

Parameters

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

Example

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  |
+---------------------+

MERGE

UPDATE

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Example

​Syntax

​Parameters

​Example

Syntax

Parameters

Example