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 vote188 views1 answer
Find a column in all tables postgres
SQL
2 votes218 views1 answer
Pandas to sql index
SQL
0 vote217 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote214 views3 answers
Alter schema sql server
SQL
4 votes214 views1 answer
How to drop a database in sql server when it is in use
SQL
5 votes272 views1 answer
Oracle source query
SQL
-1 vote199 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote187 views1 answer
Hibernate show sql xml property
SQL
2 votes239 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote203 views1 answer
Stratified sampling sql
SQL