Monday, March 30, 2020

Difference between Procedure and Trigger?

Both procedure and trigger are database objects. But they have few differences like

Database objects like function and procedure are need to call manually or explicitly.

But execution of trigger occurs automatically on call of event. Triggers execute on basis of timing, level and event.

Triggers

Triggers are database objects, which are stored in database. Triggers fires automatically based on events.