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 vote155 views1 answer
Left join in codeigniter query builder
SQL
0 vote156 views1 answer
Codeigniter dbforge add index
SQL
1 vote191 views1 answer
Insert many to many sql
SQL
1 vote219 views1 answer
Oracle transaction rollback not working
SQL
16 votes200 views6 answers
Python sqlite
SQL
1 vote146 views1 answer
Login to database mysql terminal
SQL
0 vote153 views1 answer
Postgres read table structure
SQL
0 vote229 views1 answer
Sql trigger to call stored procedure with parameters
SQL
2 votes173 views1 answer
Removing view
SQL
1 vote175 views1 answer
Sql server set variable if exists
SQL