drop, and rebuild table, or delete all rows?

I have an application that tracks a weekly SLA for something, and resets at the end of the week.

the table used is ONLY used for that, and so, we need to essentially empty the table at the end of the week. (Sunday midnight)

Question - which is better (for size and performance)

a) - just delete all rows?
b) - drop the table and recreate

its a msSQL database.

 

nm, using the SQL truncate command...

 

Yes, truncate is the way to go....along with removing all data, it will also reset the seed of your identity field if you had one.

 

Insted of dropping a table you can truncate this.because by doing this your rows will be deleted but your structure of table will remain s there.

 

yeah, I agree. Truncating is the way to go.