Differences Between : DELETE, TRUNCATE and DROP in SQL Server DELETE Command: Type of Command - DELETE is a DML (Data Manipulation Language) command. Purpose - Deletes specific rows based on ...

The DROP command in SQL is used to permanently delete a table, its structure, and all of its data from the database. The TRUNCATE command in SQL is used to quickly remove all rows from a table while ...

In general truncate and reload is the easiest option - for the reason that you don't have to worry about what's changed and any back door updates to the source database will be reflected in the ...