ROLLBACK | Rollback In SQL Server

ROLLBACK Command

This command restore the database to last committed state.

It is also used with savepoint command to jump to a savepoint in a transaction.

Syntax :

1) ROLLBACK;

2) ROLLBACK savepoint_name;

Example :

ROLLBACK save1;

Note :

We can rollback the same data that was not previously committed.

* * * * * * * * * * * * * *

In Easy Lanhguage

Rollback command used to rollback(undo) all database or particular savepoint.