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 vote251 views1 answer
Postgres 11 add primary key
SQL
2 votes280 views5 answers
Install postgresql 10 centos 7
SQL
0 vote242 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote251 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote273 views2 answers
Psql commande \gset
SQL
0 vote259 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
1 vote281 views1 answer
Quit mysql
SQL
2 votes279 views1 answer
Sql update \
SQL
0 vote224 views1 answer
Create bakupd database sqlserver
SQL
0 vote249 views1 answer
Object Information
SQL