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

9 votes283 views3 answers
Oracle undo usage by session
SQL
0 vote284 views1 answer
Check sql database table lock
SQL
0 vote307 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote313 views1 answer
Bitmap join index
SQL
0 vote256 views1 answer
Postgres create database if not exists
SQL
-1 vote288 views3 answers
SQL to LINQ converter
SQL
2 votes278 views1 answer
How to add where command in update comand with joins
SQL
0 vote290 views1 answer
Select even number id data from table
SQL
0 vote286 views1 answer
Select amount weeks between two dates mysql
SQL
2 votes265 views1 answer
Mysql add boolean column
SQL