40% Get Big Discount For a Limited time

What is the difference between Truncate and Delete?


Author Profile

author

sandeep

@sandeep

Answers

Difference between Delete & truncate command:

  1. DELETE is DML command while Truncate is DDL.
  2. DELETE is slower than Truncate
  3. DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log
  4. Truncate reset identity column number where delete can not

user

@pallav

March 03,2016 At 06:20 PM

Solution #1

Leave a Comment

message*

Search

Popular Post

Categories

Popular Tags

Subscribe Now

Get the updates, offers, tips and enhance your page building experience