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 vote150 views1 answer
Select tables with name like mysql
SQL
0 vote175 views1 answer
Add computed column to table sql server
SQL
0 vote134 views2 answers
Sqlite unix timestamp
SQL
2 votes124 views2 answers
Get all columns from table sql
SQL
0 vote143 views1 answer
Utiliser sql ligne de commande
SQL
-1 vote170 views2 answers
Sql truncate number
SQL
15 votes148 views2 answers
How to know the username of postgresql
SQL
0 vote145 views1 answer
Mysql set boolean default value
SQL
0 vote143 views1 answer
Pagination with row_number
SQL
2 votes128 views1 answer
Sql to char function with date
SQL