Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Undoes any changes made in a trigger.
ROLLBACK TRIGGER [ WITH raiserror-statement ]
The ROLLBACK TRIGGER statement rolls back the work done in a trigger, including the data modification that caused the trigger
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.
ROLLBACK TRIGGER is supported in both Watcom SQL and Transact-SQL stored procedures. ROLLBACK TRIGGER is supported by
Adaptive Server Enterprise.