What is a database trigger?

What is a database trigger?

Rating:

A database trigger executes implicitly when a triggering event such as a DML statement (INSERT, UPDATE, or DELETE) on a table, an INSTEAD OF trigger on a view, or a DDL statement (CREATE or ALTER) is issued, regardless of which database user is connected or which application is used. A database trigger also executes implicitly when some user actions or database system actions occur, e.g., when a database user logs on to the database or the database administrator (DBA) shuts down the database.

A database trigger can be a system trigger on a database or schema. A database trigger defined on a database fires for each event for all users. However, a database trigger defined on a schema fires for each event for that particular user.

Rating: