First page Back Continue Last page Image

The 4 Main types of Stored Programs

Stored procedure

Stored function

Trigger

Event

Called to Execute

Execute Automatically

Called by an Application with Database Access

Called by a SQL Statement

Automatically executes following an INSERT, UPDATE or DELETE statement

Automatically executes at a certain scheduled time