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

5 votes304 views1 answer
Sql table columns
SQL
0 vote317 views1 answer
How to inner join 4 tables in sql
SQL
10 votes297 views2 answers
Tsql merge example
SQL
14 votes316 views5 answers
Set password for postgres user ubuntu
SQL
0 vote260 views1 answer
Pl sql turn off variable substitution
SQL
3 votes296 views1 answer
Mysql insert on dupèlicate
SQL
2 votes274 views1 answer
Oracle index size calculation
SQL
0 vote259 views1 answer
Sqldf change user
SQL
0 vote294 views1 answer
How to update date value in sql
SQL
0 vote264 views1 answer
Sqlserver now
SQL