Creating Models › Target Servers for Physical Models › Database Property Editors › SQL Azure Property Editors › SQL Azure Database Support in erwin® Data Modeler › Trigger Properties › SQL Azure Triggers

SQL Azure Triggers

A trigger is a stored procedure that executes in response to an event. For example, a trigger can be executed when a row in a table is inserted, updated, or deleted. The trigger tells the DBMS how to process the SQL INSERT, UPDATE, or DELETE commands to enforce business rules. This product supports three categories of triggers in SQL Azure physical models:

Database Triggers

Define all the triggers that exist for the selected database.

Table Triggers

Define all the triggers that exist for the selected table.

View Triggers

Define all the triggers that exist for the selected view.

More information:

Define SQL Azure Table Triggers

Define SQL Azure View Triggers

Define SQL Azure Database Triggers