Chapter 9 SQL Statements
599
ROLLBACK TRIGGER statement
Use this statement to undo any changes made in a trigger.
ROLLBACK TRIGGER [ WITH
raiserror-statement
]
None.
None
"CREATE TRIGGER statement" on page 477
"ROLLBACK statement" on page 597
"ROLLBACK TO SAVEPOINT statement" on page 598
"RAISERROR statement" on page 584
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.
♦
SQL/92 Transact-SQL extension.
♦
Sybase Supported by Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...