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 vote102 views1 answer
Oracle list constraints
SQL
3 votes105 views2 answers
Postgres show table schema
SQL
0 vote108 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote106 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
1 vote101 views3 answers
Union in sql
SQL
1 vote99 views1 answer
Postgresql pass array in function
SQL
1 vote99 views2 answers
String to date postgres
SQL
0 vote103 views1 answer
Mysql terminal list table
SQL
0 vote115 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote145 views1 answer
Mysql faster delete
SQL