What is Trigger?

Ads
 

What is Trigger?

What is Trigger?

View Answers

November 18, 2010 at 1:13 PM

Hi,

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.The event can be any event including INSERT, UPDATE and DELETE. The difference between a trigger and a stored procedure is that a trigger is activated or called when an event happens in a database table, a stored procedure must be called explicitly.

For example you can have some business logic to do before or after inserting a new record in a database table.

Thanks,

Ads









Related Tutorials/Questions & Answers:
ModuleNotFoundError: No module named 'triggerd'
ModuleNotFoundError: No module named 'triggers'
Advertisements
ModuleNotFoundError: No module named 'django-triggers'
ModuleNotFoundError: No module named 'django-triggers'
ModuleNotFoundError: No module named 'django-triggers'
ModuleNotFoundError: No module named 'redis_triggers'
Version of com.hmsonline>hms-cassandra-triggers dependency
ModuleNotFoundError: No module named 'airflow-extension-triggers'
ModuleNotFoundError: No module named 'cron-schedule-triggers'
ModuleNotFoundError: No module named 'cron-schedule-triggers'
ModuleNotFoundError: No module named 'django-history-triggers'
ModuleNotFoundError: No module named 'hass-wh-triggers'
ModuleNotFoundError: No module named 'postgres-audit-triggers'
ModuleNotFoundError: No module named 'airflow-extension-triggers'
ModuleNotFoundError: No module named 'cron-schedule-triggers'
ModuleNotFoundError: No module named 'hass-wh-triggers'
Maven Dependency hms-cassandra-triggers >> 0.13.1
Maven Dependency hms-cassandra-triggers >> 0.13.3
Maven Dependency hms-cassandra-triggers >> 0.13.4
Maven Dependency hms-cassandra-triggers >> 0.14.1
Maven Dependency hms-cassandra-triggers >> 0.14.2
Maven Dependency hms-cassandra-triggers >> 0.14.4
Maven Dependency hms-cassandra-triggers >> 0.14.5
Maven Dependency hms-cassandra-triggers >> 0.15.0
Maven Dependency hms-cassandra-triggers >> 0.15.1
Maven Dependency hms-cassandra-triggers >> 0.15.3
Maven Dependency hms-cassandra-triggers >> 0.15.4
Maven Dependency hms-cassandra-triggers >> 0.15.7
Maven Dependency hms-cassandra-triggers >> 0.15.8
Maven Dependency hms-cassandra-triggers >> 1.0.0
Maven Dependency hms-cassandra-triggers >> 1.0.1

Ads