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 vote346 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote311 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote302 views1 answer
Mysql group by derived column
SQL
1 vote316 views1 answer
Pentaho + pasar de excel a sql
SQL
32 votes331 views6 answers
Sql count where
SQL
-1 vote332 views4 answers
Postgres between dates
SQL
0 vote323 views5 answers
Select concat alter table mysql
SQL
1 vote291 views1 answer
Update from select join
SQL
0 vote339 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote318 views1 answer
Sql add calculated column
SQL