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 vote297 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote322 views3 answers
Fetlife
SQL
0 vote313 views1 answer
Compare two tables to find unmatched records
SQL
3 votes456 views9 answers
Linq to sql converter online
SQL
0 vote300 views1 answer
Sql beginning of previous month
SQL
0 vote334 views1 answer
Move table to a different schema
SQL
0 vote328 views2 answers
Start mysql server using docker
SQL
0 vote266 views1 answer
Plsql trigger insert update
SQL
0 vote295 views1 answer
Get who is hired in january in sql
SQL
5 votes313 views1 answer
Mysql last day of next month
SQL