cancellare tutti i record di una tabella #4236

easiest way is SQL. open the database, go to the Execute SQL tab and run (replace my_table with your table name):

DELETE FROM my_table;

press Ctrl+Return (or the play button), then Write Changes (Ctrl+S). DB4S keeps edits in a pending transaction, so nothing is saved to the file until you write changes

optional extras:

• if the table has an AUTOINCREMENT id and you want new rows to start from 1 again: DELETE FROM sqlite_sequence WHERE name = 'my_table';
• the file won't get smaller by itself after a big delete, run VACUUM; (or Tools > Compact Database...) for that

without SQL: in Browse Data pick the table, click a cell, Ctrl+A to select the rows, then Delete Record, then Write Changes. it deletes every selected row, but for big tables the SQL way is quicker

(in italiano: DELETE FROM nome_tabella; nella scheda Execute SQL, poi Ctrl+S per salvare)