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 vote326 views1 answer
Sql server convert date to weekday
SQL
2 votes312 views2 answers
Insert all in sql
SQL
0 vote373 views1 answer
Create table in dbms cmds
SQL
21 votes330 views3 answers
Average sql
SQL
4 votes340 views1 answer
Mysql ip address data type
SQL
0 vote357 views1 answer
Sql server pivot rows to columns
SQL
0 vote340 views2 answers
How to tun mysql on ubunto
SQL
4 votes342 views3 answers
Copy table postgres
SQL
0 vote338 views2 answers
Select index table oracle
SQL
3 votes358 views1 answer
Get current month last date in sql server
SQL