Is it possible to rollback DELETE, DROP and TRUNCATE?
<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>