OK, if you don’t need the transaction then in V5 there is a DB option for delete all transactions… Run that
Then, change the DB to “MyTempDatabase” - when you do this SambaPOS will create a new SQL DB in your server called MyTempDatabase…
Take a look in SQL Management Studio and you should be able to see the table schema to re-create the structure in you main DB. Once you have done this, switch the DB back to your main one again and you should be OK.