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 vote351 views2 answers
How to update the multiple rows in sql
SQL
0 vote377 views1 answer
Sql cnvert bit to nvarchar
SQL
6 votes333 views1 answer
Oracle trigger after connect
SQL
2 votes384 views1 answer
Q operator in plsql
SQL
2 votes369 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote510 views1 answer
Sql insert exemplo
SQL
0 vote341 views1 answer
Redirection 301 htaccess nom de domaine
SQL
1 vote341 views2 answers
T-sql random number for each row
SQL
0 vote376 views3 answers
Database restoring error
SQL
1 vote346 views1 answer
User privileges postgresql information_schema
SQL