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

3 votes160 views1 answer
Oracle apex message quit website
SQL
0 vote164 views1 answer
Mysql function variable
SQL
0 vote172 views1 answer
Sauvegarde complète my sql
SQL
0 vote171 views1 answer
Docker open terminal mysql server
SQL
8 votes168 views1 answer
Oracle search source code
SQL
0 vote175 views1 answer
Psql attribute cannot login
SQL
4 votes168 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote159 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote182 views1 answer
Postgres reorder columns
SQL
50 votes195 views6 answers
Install mysql on ubuntu
SQL