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
| Column | Meaning |
|---|---|
| Trigger_name | Name of the trigger. |
| Table | Which table does this trigger affect. |
| Activation | At what time does this trigger run. |
| Event | DML 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. |
| Class | DML (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. |
| Type | There are three types of triggers:
|
| Status | Deactivated or active. |
| Definition | Trigger source code. |
Trigger details and source code
