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 vote142 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote141 views1 answer
Flask sqlalchemy remove duplicates
SQL
0 vote126 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote138 views1 answer
Sql drop procedure if exists
SQL
0 vote143 views1 answer
Sqlite3_open_v2
SQL
4 votes137 views1 answer
Oracle select first 10 rows
SQL
0 vote134 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote130 views1 answer
Strat with in sql
SQL
0 vote133 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote196 views1 answer
Run docker container with database as rds metabase
SQL