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 vote268 views1 answer
Mysql page segment
SQL
0 vote278 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote250 views1 answer
How to install Firebird
SQL
1 vote272 views1 answer
Oracle duration between timestamps
SQL
0 vote272 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote342 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote274 views1 answer
Postgres install unaccent extension
SQL
1 vote284 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote275 views1 answer
Like sql for second letter of the family name
SQL
1 vote255 views1 answer
GROUP BY clause; this is incompati
SQL