SAVEPOINT | Savepoint In SQL

SAVEPOINT Command

Savepoint command used to save temporarily transaction, so that you can rollback to that point whenevee necessary.
Savepoint command used to create savepoint after change the database.

Syntax :

SAVEPOINT savepoint_name;

Example :

SAVEPOINT save1;

Note :

If we have made a mistake in the database and use rollback without the savepoint , then it rollbacks the complete transaction and we lost all data.