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

0 vote150 views2 answers
How to check if a column exists in a SQL Server table?
SQL
3 votes111 views1 answer
Oracle wait
SQL
0 vote113 views1 answer
Sql query for displaying age from oldest to youngest
SQL
10 votes121 views2 answers
Mysql alter add foreign key
SQL
1 vote122 views1 answer
Postgres start database on linux
SQL
0 vote126 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote119 views1 answer
How to change the field size of an existing column
SQL
0 vote114 views1 answer
How to check replication lag in mySQL
SQL
1 vote115 views1 answer
Create new table in SQL from old table with data
SQL
0 vote128 views1 answer
Select nth row in mysql
SQL