Truncate table sqlite

The TRUNCATE TABLE statement is used to remove all records from a table.

SQLite does not have an explicit TRUNCATE TABLE command like other databases. Instead, it has added a TRUNCATE optimizer to the DELETE statement. To truncate a table in SQLite, you just need to execute a DELETE statement without a WHERE clause. The TRUNCATE optimizer handles the rest. Let's explain.

Normally, when you execute a DELETE statement, the database must visit each row in the table to perform the deletion. In SQLite, when you execute a DELETE statement without a WHERE clause, the TRUNCATE optimizer is run instead of the normal delete behavior. The TRUNCATE optimizer removes all data from the table without the need to visit each row in the table. This is much faster than a normal delete operation.

Source: techonthenet.com

Sqlite truncate tables command

DELETE FROM suppliers;

Source: techonthenet.com

Similar codes

0 vote375 views1 answer
Current month transactions in mysql
SQL
32 votes295 views6 answers
Insert into values select
SQL
1 vote316 views1 answer
Sql check roles
SQL
0 vote289 views1 answer
Change schema of all tables postgres
SQL
6 votes313 views2 answers
Mysqldump password in file
SQL
7 votes298 views3 answers
Select latest entry in sql table
SQL
1 vote284 views2 answers
Find a column in all tables mysql
SQL
-1 vote321 views3 answers
Error: mysql shutdown unexpectedly.
SQL
1 vote319 views2 answers
Grab part of a string sql
SQL
0 vote287 views1 answer
Search In the Data using ObjectName
SQL