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

1 vote339 views1 answer
Group_concat max length mysql
SQL
1 vote325 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote351 views1 answer
Mysql previous year
SQL
2 votes324 views1 answer
Oracle sql day of month from date
SQL
0 vote334 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote377 views1 answer
Dockerfile example for Django
SQL
0 vote308 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
1 vote309 views1 answer
Select statement to print longest name
SQL
0 vote326 views1 answer
How to drop a trigger in postgresql
SQL
11 votes311 views2 answers
MySQL DISTINCT
SQL