Home > APIs > YSQL > The SQL language > SQL statements >

TRUNCATE

Synopsis

Use the TRUNCATE statement to clear all rows in a table.

truncate ::= TRUNCATE [ TABLE ] { { [ ONLY ] name [ * ] } [ , ... ] }

Specify the name of the table to be truncated.

TRUNCATE acquires ACCESS EXCLUSIVE lock on the tables to be truncated. The ACCESS EXCLUSIVE locking option is not yet fully supported.
TRUNCATE is not supported for foreign tables.

yugabyte=# CREATE TABLE sample(k1 int, k2 int, v1 int, v2 text, PRIMARY KEY (k1, k2));

yugabyte=# INSERT INTO sample VALUES (1, 2.0, 3, 'a'), (2, 3.0, 4, 'b'), (3, 4.0, 5, 'c');

yugabyte=# SELECT * FROM sample ORDER BY k1;

 k1 | k2 | v1 | v2
----+----+----+----
  1 |  2 |  3 | a
  2 |  3 |  4 | b
  3 |  4 |  5 | c
(3 rows)

yugabyte=# TRUNCATE sample;

yugabyte=# SELECT * FROM sample;

 k1 | k2 | v1 | v2
----+----+----+----
(0 rows)