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 vote103 views1 answer
Install mysql for fedora 34
SQL
1 vote123 views1 answer
Oracle compile schema
SQL
2 votes107 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote114 views1 answer
Mysql beautifier terminla
SQL
5 votes153 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
5 votes121 views1 answer
Purge undo tablespace usage
SQL
1 vote99 views2 answers
Mysql filter by date mount
SQL
0 vote129 views1 answer
SELECT statement to find the specific cell in database table
SQL
42 votes193 views6 answers
Rename table sql server
SQL
0 vote152 views1 answer
Sql select without column name
SQL