ASA SQL Reference
  SQL Statements

ROLLBACK TRIGGER statement

Description 

Use this statement to undo any changes made in a trigger.

Syntax 

ROLLBACK TRIGGER [ WITH raiserror-statement ]

Usage 

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.

Permissions 

None.

Side effects 

None

See also 

CREATE TRIGGER statement

ROLLBACK statement

ROLLBACK TO SAVEPOINT statement

RAISERROR statement [T-SQL]

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Supported by Adaptive Server Enterprise.