DDL Triggers
DDL triggers allow restrictions to be placed on users who attempt to create, alter or drop a DDL object.Their other purposes is to keep a metadata change log.
DDL triggers fire on specified metadata changes events in a specified phase.BEFORE
triggers run before changes to system tables.AFTER
triggers run after changes in system tables.
Important
|
The event type |
In a sense, DDL triggers are a sub-type of database triggers.