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

21 votes116 views1 answer
Cheatsheet for sql
SQL
0 vote124 views1 answer
Empty table sqlite
SQL
0 vote117 views1 answer
Sql server manager close connection
SQL
6 votes125 views2 answers
Mysql first day of month
SQL
0 vote81 views1 answer
Flask_sqlalchemy install
SQL
0 vote139 views1 answer
Dual in db2
SQL
28 votes117 views4 answers
Show tables mysql
SQL
0 vote169 views1 answer
Mysql collation portugues brasil
SQL
3 votes118 views2 answers
Mysql time
SQL
0 vote123 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL