Define SQL Azure Database Triggers
Use the SQL Azure Database Trigger Editor to define the triggers that exist for a database in a SQL Azure physical model.
Note: You cannot use the SQL Azure Database Trigger Editor until you have created a SQL Azure database object in your model.
To define SQL Azure database triggers
The SQL Azure Database Editor opens.
The SQL Azure Database Trigger Editor opens.
Note: Click New on the toolbar to create a new database trigger. Use the Enter filter text box to filter a very large list of database triggers to quickly locate the one that you want to define.
Displays the database trigger name. You can change the trigger name in this field.
Specifies when the database trigger is executed. Make a selection from the drop-down list.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
Specifies the database trigger events. If any of the selected events, or actions, occur in the database, the database trigger is executed. Select or clear the check boxes for the event groups and events that execute the database trigger.
Specifies the permission level in effect when the database trigger is executed.
Specifies the user whose permissions are in effect for the execution of the database trigger.
Note: This option is only available if you have selected the Execute As User option in the Type drop-down list.
Specifies whether the database trigger is enabled or disabled.
The database trigger is defined and the SQL Azure Database Trigger Editor closes and you are returned to the SQL Azure Database Editor.
The SQL Azure Database Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|