User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To undo any changes made in a trigger.

Syntax

     ROLLBACK TRIGGER[ WITHraiserror-statement ]

Usage

In a trigger

Permissions

Must be connected to the database.

Side effects

None

See also

• CREATE TRIGGER statement
• ROLLBACK statement
• ROLLBACK TO SAVEPOINT statement
• "Transact-SQL 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.