rollback trigger

Rolls back the work done in a trigger, including the data modification that caused the trigger to fire, and issues an optional raiserror statement.

Syntax

rollback trigger
	[with raiserror_statement]

Parameters

Examples

Usage

  • When rollback trigger is executed, the SAP ASE server aborts the currently executing command and halts execution of the rest of the trigger.

  • If the trigger that issues rollback trigger is nested within other triggers, the SAP ASE server rolls back all work done in these triggers up to and including the update that caused the first trigger to fire.

  • The SAP ASE server ignores a rollback trigger statement that is executed outside a trigger and does not issue a raiserror associated with the statement. However, a rollback trigger statement executed outside a trigger but inside a transaction generates an error that causes the SAP ASE server to roll back the transaction and abort the current statement batch.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

No permission is required to use rollback trigger.

Related reference
create trigger
raiserror
rollback