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

5 votes214 views2 answers
Sql constraint check value in list
SQL
3 votes190 views1 answer
Oracle wait
SQL
3 votes201 views1 answer
Oracle revoke
SQL
0 vote207 views1 answer
Sql trying to delete database in use
SQL
0 vote192 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote248 views1 answer
Sql doesn't contain
SQL
2 votes214 views3 answers
Copy data from one table column to another table column in sql
SQL
5 votes207 views2 answers
Oracle rename table
SQL
0 vote204 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
-1 vote206 views3 answers
Create temp table in sql
SQL