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 vote179 views1 answer
Alter precision
SQL
0 vote236 views1 answer
Postgres extract number from string
SQL
46 votes262 views4 answers
Create column sql
SQL
0 vote184 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote185 views1 answer
Ms sql unique
SQL
3 votes210 views3 answers
1396(hy00) mysql error
SQL
0 vote198 views1 answer
Sqlserver now
SQL
0 vote206 views2 answers
Insert data mysql with cmd
SQL
12 votes206 views6 answers
Change mysql root password
SQL
0 vote190 views1 answer
Timestamp(0) postgresql
SQL