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 vote372 views1 answer
On delete set default
SQL
0 vote346 views2 answers
Sqlite unique
SQL
1 vote565 views2 answers
Sql unique rows
SQL
12 votes345 views1 answer
Docker run mysql image
SQL
0 vote344 views1 answer
Turn on foreign keys check mysql
SQL
1 vote342 views1 answer
What is intersect
SQL
13 votes355 views6 answers
Mysql update from select
SQL
0 vote341 views2 answers
Sql server select where date
SQL
3 votes397 views1 answer
Postgres count distinct
SQL
1 vote404 views1 answer
Oracle show execution plan
SQL