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 vote177 views1 answer
Vbscript clean up ADODB.Recordset
SQL
53 votes534 views6 answers
Sql server alter column
SQL
0 vote276 views1 answer
Mssql unique key accept nulls
SQL
10 votes170 views4 answers
Sql pagination
SQL
1 vote171 views1 answer
Oracle apex run 404
SQL
6 votes177 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote194 views1 answer
Sql server create constraint
SQL
0 vote188 views1 answer
Regex any word except sql
SQL
2 votes165 views3 answers
Current month mysql query
SQL
0 vote164 views1 answer
Add sqlite3 in lumen
SQL