MariaDB TRUNCATE table Statement
In MariaDB database, TRUNCATE TABLE statement is used to delete all records from a table. It is same as DELETE statement without a WHERE clause.
Note: If you use the TRUNCATE table statement, the table will be deleted permanently and cannot be rolled back.
Let's truncate the table "Students".
The TRUNCATE query is executed successfully. You can see that the records of "Student" table have been deleted permanently.
There is no data in "Student" table.