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

1 vote248 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
6 votes247 views1 answer
Allsource oracle
SQL
5 votes257 views1 answer
AND OR NOT operators sql
SQL
6 votes277 views2 answers
Mysql concatenate two columns into one
SQL
0 vote260 views3 answers
Postgresql grant alter table to user
SQL
2 votes282 views1 answer
Metasploit start postgresql
SQL
0 vote262 views1 answer
Sql count matching group by
SQL
0 vote287 views1 answer
Sql pivot without aggregate
SQL
0 vote253 views1 answer
Grant privileges mysql to database 1064
SQL
2 votes253 views1 answer
How to make insert script from table in SQL server
SQL