DOTNET: Difference Between Drop And Truncate

Monday, July 30, 2012

Drop Command: If we want to destroy the existing tables present in the database we use the Drop Command.

Syntax: DROP TABLE <TableName>

Example : Drop Table Customers

Truncate Command: Removes all rows from a table. Here the columns Remains the same so that you can add New Records in the table.

Note: We do not have Where Clause Here.

Syntax: TRUNCATE TABLE <TableName>

Example : TRUNCATE TABLE Customers

Truncate

Truncate table is faster in execution.

Truncate Releases Memory

It will Reset Identity

It Deletes all the records

DOTNET