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 vote205 views1 answer
Postgres 11 add primary key
SQL
1 vote209 views2 answers
Mysql does sentance contain word
SQL
1 vote198 views1 answer
How to get mysql db size
SQL
11 votes222 views1 answer
Sql insert multiple rows from select
SQL
1 vote219 views1 answer
Sql headers delphi
SQL
0 vote256 views1 answer
Compress sql file database ubuntu
SQL
2 votes210 views1 answer
Select from array in psql
SQL
0 vote227 views1 answer
Select even number id data from table
SQL
0 vote231 views3 answers
Mysql regex replace
SQL
0 vote207 views1 answer
Sql query to delete row by id
SQL