interview

Home / DeveloperSection / Interviews / What is the difference between DELETE and TRUNCATE commands?

Ask Question
Rahul Roi

Rahul Roi

Follow
I'm a professional writer and software developer with more than 10 years of experience. I have worked for a lot of businesses and can share sample works with you upon request. Chat me up and let's get started.....

Can you answer this question?

Answer

1 Answers

Rahul Roi

Rahul Roi

06-May-2019

Mostly DELETE command is used to remove rows from the table, and WHERE clause can be used for conditional set of parameters. Here Commit and Rollback operation can be performed or used after delete statement.

Into the TRUNCATEcommand removes all rows from table. And the Truncate operation cannot be rolled back. In other word, Commit and Rollback operation can't be performed in TRUNCATE operation.

Delete command is used to delete a row in a table.Truncate is used to delete all the rows from a table.
You can rollback data after using delete statement.You cannot rollback data.
It is a DML command.It is a DDL command.
It is slower than truncate statement.It is faster.
MindStick Training

Liked By