TRUNCATE TABLE
DestructiveEmpty a table fast
TRUNCATE TABLE <name>;
Wipes every row instantly, keeping the structure. No WHERE, often no rollback — reset use only.
Examples
TRUNCATE TABLE session_log;Empty a log table
Syntax
TRUNCATE TABLE name;
Before you run it
All rows vanish immediately.
Related commands
- DELETEDelete rows
- Dump / backupBack up a DB
Check it once more before you run it
Some commands cannot be undone if one flag is wrong. An on-device reference works with no connection. Free to install, no ads.
Get it free on the App Store