Editing Database trigger (section)

=== Microsoft SQL Server ===

MS SQL Server supports trigger for DML and DDL statement plus special trigger "logon".

The scope of DDL triggers can be a database (CREATE TRIGGER name ON DATABASE ...) or the entire SQL Server instance (CREATE TRIGGER name ON ALL SERVER). When you use the entire instance, you can capture all events executed on commands that have server-level scope as well as any commands that have database-level scope in the SQL instance.

A list of all available firing events in Microsoft SQL Server for DDL triggers is available on [[Microsoft Docs]].<ref>{{Cite web|url=https://docs.microsoft.com/en-us/sql/relational-databases/triggers/ddl-events?view=sql-server-ver15|title=DDL Events - SQL Server|date=15 March 2023 }}</ref>

Performing conditional actions in DML triggers (or testing data following modification) is done through accessing the pseudo tables (temporary ones) Inserted and Deleted tables. DML trigger are always "FOR EACH STATEMENT" but can be code at row event ("FOR EACH ROW")  using a cursor on the inserted/deleted pseudo tables.