Object Oriented Style Procedural Style Delete old records by date Delete table Truncate is the fastest method to delete all data in a table as the table is dropped and re-creaed.