sqlite3 app.db 'DROP TABLE users;'

Category: Databases & SQL

sqlite3 app.db 'DROP TABLE users;'

Delete a table and all its data

Removes the table, its rows, and its indexes — irreversible. Export a .dump or .backup first if there is any doubt. Related: DELETE FROM users keeps the table.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.