Can you tell me the difference between DELETE & TRUNCATE commands?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / guest

15 Answers
20466 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can you tell me the difference between DELETE & TRUNCATE commands?..

Answer / pankaj kumar upadhyay

1) When we use delete command that time we will use
conditon or without conditon but when we use truncate
command so that time we will not use condition.

2)delete can roll back but truncate is not rollback.

3)Truncate is faster compare delete command.

4)delete is DML command while Truncate is DDL.

Is This Answer Correct ?

1 Yes

0 No

Can you tell me the difference between DELETE & TRUNCATE commands?..

Answer / afzal_aziz

http://weblogs.sqlteam.com/mladenp/archive/2007/10/03/SQL-
Server-Why-is-TRUNCATE-TABLE-a-DDL-and-not.aspx

Is This Answer Correct ?

2 Yes

3 No

Can you tell me the difference between DELETE & TRUNCATE commands?..

Answer / kapil

Delete: is a DML command.
Truncate: is a DDL command.

Delete & Truncate both can be rolled back.
Untill you have not commit transaction.

Is This Answer Correct ?

1 Yes

2 No

Can you tell me the difference between DELETE & TRUNCATE commands?..

Answer / amita

Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.

Is This Answer Correct ?

3 Yes

28 No

Can you tell me the difference between DELETE & TRUNCATE commands?..

Answer / saradhi

Truncate command result can be rolled back as it is not
made an entry in the log where as Delete command result
can't be rolled back

Is This Answer Correct ?

5 Yes

47 No

Post New Answer