"If you press the SECOND dorsal fin-spine on a trigger fish, an amazing event
occurs. The FIRST dorsal fin-spine goes down too."
—
Applied Ichthyology
In this chapter, we'll describe SQL Triggers in detail, and show you the syntax to use to create, alter and destroy them.
-
Trigger
A Schema may contain zero or more Triggers. An SQL Trigger is a named chain... -
CREATE TRIGGER Statement
The CREATE TRIGGER statement names a new Trigger and defines the Trigger's ... -
Activation of Triggers
In our discussion of the CREATE TRIGGER statement, we made this true, but i... -
Trigger Examples
The following four scenarios show the use of a Trigger in a real-life situa... -
Triggers versus Constraints
The essential idea of a Trigger is that if you change a Table, you cause a ... -
DROP TRIGGER Statement
The DROP TRIGGER statement destroys a Trigger. The required syntax for the ... -
Dialects
Triggers are not part of SQL-92 or the SQL3 Core SQL specifications, but ma...
