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 votes91 views1 answer
Sql float to int
SQL
4 votes261 views1 answer
Oracle table statistics
SQL
0 vote187 views1 answer
Sql commands in android
SQL
0 vote144 views1 answer
Systems sql
SQL
0 vote143 views1 answer
Sql server isnull function nor working count
SQL
21 votes163 views6 answers
Update sql
SQL
16 votes131 views3 answers
Delete row psql
SQL
0 vote135 views1 answer
Min salary in sql
SQL
0 vote124 views1 answer
Show specific events on mysql
SQL
1 vote146 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL