ALTER EVENT statement
388
"CREATE EVENT statement" on page 435
This statement allows you to alter an event definition created with CREATE
EVENT. Possible uses include the following:
♦ You can use ALTER EVENT to change an event handler during
development.
♦ You may want to define and test an event handler without a trigger
condition or schedule during a development phase, and then add the
conditions for execution using ALTER EVENT once the event handler
is completed.
♦ You may want to disable an event handler temporarily by disabling the
event.
DELETE TYPE clause Removes an association of the event with an event
type.
ADD | MODIFY | DELETE SCHEDULE clause Change the definition of
a schedule. Only one schedule can be altered in any one ALTER EVENT
statement.
WHERE clause The WHERE NULL option deletes a condition.
For descriptions of most of the parameters, see "CREATE EVENT
statement" on page 435.
Description
Parameters
To Next Page
Loading...