title: Is it possible to rollback DELETE, DROP and TRUNCATE?
body: <p>We can rollback a delete query but not so for truncate and drop. When I execute queries then successfully done with rollback in delete, drop &amp; truncate.</p>
  
  <p>We can rollback the data in conditions of Delete, Truncate &amp; Drop.
  But must be used Begin Transaction before executing query Delete, Drop &amp; Truncate.</p>
  
  <p>Here is example:</p>
  
  <pre><code>Create Database Ankit
  
  Create Table Tbl_Ankit(Name varchar(11))
  
  insert into tbl_ankit(name) values('ankit');
  insert into tbl_ankit(name) values('ankur');
  insert into tbl_ankit(name) values('arti');
  
  Select * From Tbl_Ankit
  
  /*======================For Delete==================*/
  Begin Transaction
  Delete From Tbl_Ankit where Name='ankit'
  
  Rollback
  Select * From Tbl_Ankit
  
  /*======================For Truncate==================*/
  Begin Transaction
  Truncate Table Tbl_Ankit 
  
  Rollback
  Select * From Tbl_Ankit
  
  /*======================For Drop==================*/
  Begin Transaction
  Drop Table Tbl_Ankit 
  
  Rollback
  Select * From Tbl_Ankit
  </code></pre>