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

12 votes199 views6 answers
Between in sql
SQL
4 votes200 views1 answer
Oracle error line
SQL
0 vote211 views1 answer
How much space does sql server take per row
SQL
0 vote248 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote222 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote203 views1 answer
Mysql dump for selected row
SQL
1 vote215 views1 answer
Floor function in sql oracle
SQL
16 votes190 views1 answer
CTE statement sql server
SQL
1 vote204 views1 answer
Oracle nvl2
SQL
0 vote192 views2 answers
Database owner can't create new tables postgres
SQL