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

61 votes313 views6 answers
Mysql add column
SQL
0 vote128 views1 answer
Jenkins SQLCMD run
SQL
0 vote120 views1 answer
Openquery insert into linked server
SQL
0 vote122 views1 answer
Sql menampilkan data tabel
SQL
16 votes150 views5 answers
Select last row in sql
SQL
-1 vote79 views2 answers
Datetime sql server week
SQL
5 votes120 views1 answer
Mysql add user with all privileges
SQL
0 vote171 views1 answer
How to check rollback status in oracle
SQL
22 votes231 views4 answers
Tsql rename table
SQL
6 votes133 views1 answer
Oracle trigger after logon on schema
SQL