PostgreSQL supports "Event Triggers" which is defined as,
To supplement the trigger mechanism discussed in Chapter 39, PostgreSQL also provides event triggers. Unlike regular triggers, which are attached to a single table and capture only DML events, event triggers are global to a particular database and are capable of capturing DDL events.
DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords
CREATE
,ALTER
,DROP
,GRANT
,DENY
,REVOKE
orUPDATE STATISTICS
. Certain system stored procedures that perform DDL-like operations can also fire DDL triggers.
Oracle simply calls them "Triggers". Is there any standardized functionality that provides this functionality?
Best Answer
The SQL Spec currently only says this about Triggers,
Without any further mention, I believe the spec does not currently address this functionality at all.
Formatting slightly modified from the spec. I turned it into a list. Spec used "Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework)"