What is the different between Truncate and Delete ?

spot_img

Share

Truncate deletes all items and delete only deletes each row
Correct Answer!
Truncate resizes the data page of a table and delete performs operations on each row
Truncate is used to resize columns of nvarchar type whereas delete actually deletes data

Leave a Reply

Read more

More for you