Reference Manual
   CHAPTER 9. SQL Statements     

ROLLBACK TRIGGER statement

Function 

To undo any changes made in a trigger.

Syntax 

ROLLBACK TRIGGER [ WITH raiserror-statement ]

Permissions 

Must be connected to the database.

Side effects 

None

See also 

CREATE TRIGGER statement

ROLLBACK statement

ROLLBACK TO SAVEPOINT statement

RAISERROR statement

Description 

The ROLLBACK TRIGGER statement rolls back the work done in a trigger, including the data modification that caused the trigger to fire.

Optionally, a RAISERROR statement can be issued. If a RAISERROR statement is issued, an error is returned to the application. If no RAISERROR statement is issued, no error is returned.

If a ROLLBACK TRIGGER statement is used within a nested trigger and without a RAISERROR statement, only the innermost trigger and the statement which caused it to fire are undone.

Standards and compatibility 

• SQL/92     Transact-SQL extension.

• Sybase     Supported by Adaptive Server Enterprise.