Deleting Rows

To remove rows from a table, use delete from:

delete from main.users;

This deletes all rows in the table. TempestDB reports how many rows were removed, so you should see 3 rows changed after running that.

Verify the table is now empty:

select * from main.users;