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

2 votes133 views2 answers
How to get capital letter first in sql
SQL
0 vote144 views1 answer
Postgres copy command
SQL
19 votes172 views6 answers
Create table sqlite
SQL
0 vote149 views1 answer
Sql server alter table add column tinyint
SQL
0 vote111 views1 answer
Expose db in virtualbox
SQL
2 votes157 views2 answers
Postgres add column integer
SQL
0 vote130 views2 answers
Influxdb delete measurement based on date
SQL
0 vote146 views1 answer
Oracle archivelog usage
SQL
3 votes174 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
0 vote174 views1 answer
Sql cheetsheet
SQL