Reference and syntax for the TRUNCATE TABLE command.
Removes all rows from a table.
TRUNCATE TABLE <table_name>
<table_name>
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 | +---------------------+