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;