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 vote198 views1 answer
Insert data from stored procedure into table
SQL
0 vote181 views1 answer
Mysql could not fetch tables
SQL
0 vote207 views1 answer
Compress sql file database ubuntu
SQL
11 votes194 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
8 votes171 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote236 views1 answer
Hierarchal database table
SQL
8 votes163 views1 answer
Sql remove characters from string right
SQL
0 vote183 views1 answer
Copy data from one postgres container to another
SQL
8 votes193 views3 answers
Postgres database sizes
SQL
3 votes172 views3 answers
Mysqldump: couldn
SQL