Re: How to delete all table's data
"delete * from table" will delete all rows, but will not reset sequences (i.e. auto-incrementing values like many primary keys) whereas "truncate table" will wipe everything and basically reset it as if no data had ever been stored in that table. So it just depends on which one works best for your needs.
|