>Not sure if this is the optimal one, but if the structure of the table remains the same, you can export data into text format and then delete (truncate) and import from the text file.
No, I need something that will do everything in regards to the table such as primary key and indexes.