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 vote363 views1 answer
Bitmap join index
SQL
11 votes333 views3 answers
Sqlite3 create table from another table
SQL
3 votes325 views1 answer
Oracle revoke
SQL
-1 vote342 views1 answer
Sql show custom constraints
SQL
5 votes327 views1 answer
Alter table add comment oracle
SQL
1 vote392 views1 answer
Oracle select first row order by
SQL
2 votes324 views1 answer
Sql server find table name
SQL
0 vote321 views1 answer
Opensuse start MySQL
SQL
1 vote339 views1 answer
How to unlock table in mysql
SQL
0 vote327 views1 answer
Oserror mysql_config not found virtualenv
SQL