`THROW` Statement

Throws an error, causing code execution to jump to an enclosing CATCH block.

Syntax

See More

THROW; THROW error-message;

Parameters

error-message: text (optional)
The value to be returned from the ERROR_MESSAGE function. If not provided, then the value from the last thrown error is retained; this allows a CATCH block to re-throw an error without changing it.

Examples

THROW 'Oops';
Throws an error such that ERROR_MESSAGE() returns "Oops".
THROW;
Re-throws the last thrown error without changing it. Do this inside of a CATCH block.