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 vote229 views1 answer
Sql server count all tables rows
SQL
4 votes211 views1 answer
Wilayah indonesia database
SQL
0 vote228 views1 answer
Soql user profile
SQL
0 vote254 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote241 views1 answer
Oracle sql add column auto generated value
SQL
1 vote246 views1 answer
Window function mysql
SQL
1 vote231 views1 answer
Sql in array query
SQL
0 vote214 views1 answer
Add column to table with default value plsql
SQL
0 vote220 views1 answer
Sql create table with datetime automatically
SQL
0 vote253 views1 answer
SQL-Arten
SQL