difference between delete and truncate

[jamesravid]

Just wanted to add one more point.

Truncate is a DDL command and Delete is a Dml command.

DDL statements perform commit implicitly. That is why your changed are committed automatically when ever you perform a DDL statement ( Create,Alter etc).

DML statements does not commit your changes. You have to commit explicitly inorder to save your changes. Examples of DML commands are insert,update, delete etc.

[vcyogi]

Add one more point also

When Delete the Particular row the Corresponding Delete Trigger(if exists) Fire.
In Case of Truncate the Trigger is not fired.