Member Avatar for firoz.raj

Can anyone tell me the difference between Truncate and delete
Command .Kindly let me know the idea.Any help would be highly
appreciated.

  • 3 Contributors
  • 2 Replies
  • 81 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for MahiPV

DELETE is a regular DML statement, using which selective records can be deleted with the WHERE clause and if it is a part of a transacation then the DELETE can be rolled back. Where as TRUNCATE is a DDL and it cannot be rolled back(issues an internal commit) and cannot use the WHERE clause.

Member Avatar for debasisdas

Delete
-----------
1. DML
2. Affects only data.
3. Data can be rolled back after this command.

Truncate
----------------
1. DDL
2. Affects both data and structure (resets the High Water Mark)
3. Data can't be rolled back after this command.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.