Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What is the difference between DELETE and TRUNCATE?

Nice?Vote!
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points) edited 1 year ago by R

1 Answer

Nice?Vote!
Truncate:1)deletes all the data but the strucure of table remains 2)Faster Compared to delete.3)truncate is autocommited statment.
delete:1)deletes all data but  the structure remains same.2)slow compared to truncate.3)Delete is not auto commited.
answered 10 months ago by anonymous

Related questions