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

0 vote105 views1 answer
Check if due date is less than todays date sql
SQL
1 vote182 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
28 votes110 views6 answers
Distinct sql
SQL
1 vote145 views1 answer
Sql select where id not exists in another table
SQL
2 votes167 views1 answer
Laravel sql String
SQL
0 vote154 views1 answer
Pass array parameter to stored procedure c#
SQL
2 votes150 views2 answers
Mysql limit
SQL
0 vote205 views1 answer
Sqlite schema structure of a relational database
SQL
4 votes178 views1 answer
How to check last gather stats on table in oracle
SQL
4 votes137 views2 answers
Sql table
SQL