Triggers from database

What are triggers?

An SQL trigger is a database object that is fired when an event occurs in a database. We can run an SQL query that will "do something" on a database whenever there is a change in a database table, such as a record being inserted, updated, or deleted. For example, a trigger can be set on a record insert in a database table.


Triggers from database: toolbar

You can export the table to various formats: PDF, XLS, XLSX, RTF, CSV, DOCX, TXT, HTML, MHT

Triggers from database: overzicht en lijst

Trigger_nameName of the trigger.
TableWhich table does this trigger affect.
ActivationAt what time does this trigger run.
EventDML triggers are executed when a user attempts to modify data through a Data Manipulation Language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.
ClassDML (Data Modification Language) triggers.
This is the most commonly used class of triggers. In this case, the trigger event is a data change statement; it can be an insert, update, or delete statement, either in a table or in a view.

There are three types of triggers:

  • Data Manipulation Language (DML) triggers
  • Data Definition Language (DDL) triggers
  • Login triggers.
StatusDeactivated or active.
DefinitionTrigger source code.

Trigger details and source code