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

3 votes206 views2 answers
Sql get month name
SQL
1 vote231 views1 answer
Ubuntu access database from terminal
SQL
0 vote190 views1 answer
How to print out column name differently in mysql
SQL
0 vote250 views1 answer
Check database restore status sql script
SQL
0 vote254 views1 answer
Plpgsql create function
SQL
8 votes187 views3 answers
Postgresql connection string c#
SQL
0 vote195 views3 answers
Create and attach user to a postgresql database
SQL
4 votes223 views3 answers
Sqlite show columns
SQL
0 vote193 views1 answer
How to select all fieldsin a soql query
SQL
0 vote185 views1 answer
Distinct data types in a table sql query
SQL