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 vote349 views1 answer
Sql server datetime
SQL
0 vote334 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote341 views1 answer
Import excel to sql
SQL
1 vote390 views3 answers
Read all columns of a table sql
SQL
0 vote301 views1 answer
Kannst du deine finger trainieren
SQL
1 vote354 views1 answer
Mysql check string don't have number
SQL
4 votes345 views1 answer
Mysql not equal
SQL
0 vote430 views1 answer
Mysql show schema
SQL
4 votes343 views2 answers
What is table in sql
SQL
0 vote335 views1 answer
Mysql select row with min date
SQL