SQL - TRUNCATE Table Statement

The TRUNCATE statement is used to delete all rows from a table in the database. It works the same as the DELETE statement, but you cannot use the WHERE clause with the TRUNCATE statement. The deleted rows using the TRUNCATE statement cannot be recovered. It deletes the rows permanently.

Syntax

TRUNCATE TABLE table_name;

The following command will remove all data from the Employee table in SQL Server, Oracle, MySQL, PostgreSQL databases.

SQL Script: Truncate Table Statement

TRUNCATE TABLE Employee;

The TRUNCATE command is not supported in SQLite. But alternatively, the DELETE command can be used to Delete all the data from the table.

SQL Script: Delete Rows in SQLite

DELETE FROM Employee;