Description

The SQL keyword TRUNCATE TABLE is used to delete all the records from a table, leaving the table structure as is, which makes the table empty.

  • It only deletes all the data from a table and makes it empty.
  • The table structure is untouched.

The below SQL deletes all the data from a table.

TRUNCATE TABLE users;

Related Links