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

4 votes116 views1 answer
List tables sqlite
SQL
0 vote128 views1 answer
Find how many tables in database sql query
SQL
0 vote101 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote100 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
1 vote103 views1 answer
Alter table column size oracle
SQL
1 vote108 views1 answer
Mysql text to decimal
SQL
2 votes122 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote102 views1 answer
Get enginge db mysql
SQL
6 votes105 views2 answers
What is non relational database
SQL
11 votes122 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL