what is difference between delete and truncate?

On 2014-06-21 01:19:26.0
brajeshkumar

These are the some differences between delete and truncate :

Delete :

• Delete the data one by one.
• Yo can rollback your previous data.
• It works slower than truncate.

Truncate :

• It will drop the table in one shot and recreate a new one with same schema.
• Once data is lost you can do rollback.
• It works faster than Delete.

On 2014-06-22 22:17:56.0
hablu