What is Trigger?

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,









Related Tutorials/Questions & Answers:
What are the types of triggers?
ModuleNotFoundError: No module named 'triggerd'
Advertisements
Types of Triggers
ModuleNotFoundError: No module named 'triggers'
TRIGGERS
ModuleNotFoundError: No module named 'django-triggers'
ModuleNotFoundError: No module named 'django-triggers'
ModuleNotFoundError: No module named 'redis_triggers'
ModuleNotFoundError: No module named 'django-triggers'
Triggers - JSP-Servlet
More About 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 '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 'django-history-triggers'
ModuleNotFoundError: No module named 'hass-wh-triggers'
Maven Repository/Dependency: com.hmsonline | hms-cassandra-triggers
Maven Dependency hms-cassandra-triggers >> 0.13.1
Maven Dependency hms-cassandra-triggers >> 0.13.2
Maven Dependency hms-cassandra-triggers >> 0.13.3
Maven Dependency hms-cassandra-triggers >> 0.13.4
Maven Dependency hms-cassandra-triggers >> 0.14.0
Maven Dependency hms-cassandra-triggers >> 0.14.1
Maven Dependency hms-cassandra-triggers >> 0.14.2
Maven Dependency hms-cassandra-triggers >> 0.14.3
Maven Dependency hms-cassandra-triggers >> 0.14.4
Maven Dependency hms-cassandra-triggers >> 0.14.5
Maven Dependency hms-cassandra-triggers >> 0.14.6
Maven Dependency hms-cassandra-triggers >> 0.15.0
Maven Dependency hms-cassandra-triggers >> 0.15.1
Maven Dependency hms-cassandra-triggers >> 0.15.2
Maven Dependency hms-cassandra-triggers >> 0.15.3
Maven Dependency hms-cassandra-triggers >> 0.15.4
Maven Dependency hms-cassandra-triggers >> 0.15.6
Maven Dependency hms-cassandra-triggers >> 0.15.7
Maven Dependency hms-cassandra-triggers >> 0.15.8
Maven Dependency hms-cassandra-triggers >> 0.15.9
Maven Dependency hms-cassandra-triggers >> 1.0.0
Maven Dependency hms-cassandra-triggers >> 1.0.1
Implementing more than one Job Details and Triggers
Cron Expression for Cron Triggers
What is difference between TRUNCATE & DELETE
what is bit
what is hibernate.archive.autodetection
what is hibernate.archive.autodetection

Ads