TRUNCATE is a command used to delete the data from the table. Unlike DELETE FROM without WHERE clause, this command cannot be rolled back. This command commits an open transaction in this connection.
Syntax
Following is the generic syntax of the truncate command.
TRUNCATE TABLE tableName
Example
In this example, we will truncate a table named test using the following query.
TRUNCATE TABLE test;
The above query produces the following output.
(6) row (s) effected
