Name
RAISE — Indicate an error condition
Syntax

Description
The RAISE expression isn’t an expression in the
traditional sense. Rather than producing a value, it provides a
means to raise an error exception. The RAISE expression can only be used in the body
of a trigger. It is typically used to flag a constraint
violation, or some similar problem. It is common to use a
RAISE expression in
conjunction with a CASE
expression, or some other expression that selectively executes
subexpressions depending on the logic of the SQL
statement.
See Also
CREATE TRIGGER [SQL Cmd, Ap C]
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access