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

5 votes185 views1 answer
Mysql change primary key
SQL
6 votes208 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote197 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote181 views1 answer
Postgres create database if not exists
SQL
0 vote197 views1 answer
Declare or use variable in snowflake
SQL
0 vote227 views1 answer
Mysql dump for selected row
SQL
0 vote184 views1 answer
Mysql disable query caching
SQL
0 vote207 views1 answer
Migration graphql
SQL
1 vote218 views1 answer
Mysql select and count left join
SQL
0 vote142 views1 answer
Ms sql print more than 1 variable
SQL