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 vote160 views2 answers
Mysql type conversion
SQL
5 votes191 views2 answers
Postgresql add not null constraint
SQL
1 vote170 views1 answer
Join first name and last name sql
SQL
5 votes170 views2 answers
Copy data from one database to another
SQL
0 vote306 views1 answer
Android sqlite add column if not exists
SQL
5 votes235 views3 answers
Create function in postgresql
SQL
0 vote169 views1 answer
Insert or update cassandra
SQL
1 vote223 views2 answers
Laravel jwt generate token
SQL
0 vote186 views1 answer
Postgres reorder columns
SQL
0 vote215 views1 answer
Change date in pivot table to month in sql server
SQL