Physical Modeling › SQL Server Physical Property Editors › SQL Server Database Objects › SQL Server Triggers › Define SQL Server Table Triggers

Define SQL Server Table Triggers

Use the SQL Server Table Trigger Editor to define the stored procedures that exist for a table in a SQL Server 2005/2008 physical model.

To define SQL Server table triggers

1. Click Triggers, Table on the Database menu.

   The SQL Server Table Trigger Editor opens.

2. Select the table from the Table drop-down that contains the trigger that you want to define, select the trigger, and work with the following options:

   Note: Click New on the toolbar to create a new table trigger.

   • Name

     Displays the table trigger name. You can change the trigger name in this field.

   • Schema

     Specifies the schema for the table trigger. Select a schema from the drop-down list or click the New icon to open the SQL Server Schema Editor and create one.

   • Insert

     Specifies to execute the table trigger on INSERT.

   • Update

     Specifies to execute the table trigger on UPDATE.

   • Delete

     Specifies to execute the table trigger on DELETE.

   • Trigger Timing

     Specifies when the table trigger is executed.

   • Generate

     Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:
   • Encryption Enabled

     Specifies that the table trigger is encrypted in the database.

   • Not for replication

     Specifies that the table trigger is not invoked as part of database replication.

   • Enabled State

     Specifies whether the table trigger is enabled or disabled.

   • Type

     Specifies the permission level in effect when the table trigger is executed.

   • Select User

     Specifies the user whose permissions are in effect for the execution of the table trigger.

     Note: This option is only available if you have selected the Execute As User option in the Type drop-down list.

   • Referential Integrity Constraints

     Displays the relationships and tables associated with the table trigger.

4. Click the Code tab to define the code type for the table trigger.
5. Click the Expanded tab to view expanded code for the table trigger.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the table trigger.
7. (Optional) Click the UDP tab to work with user-defined properties for the table trigger.
8. Click Close.

   The table trigger is defined and the SQL Server Table Trigger Editor closes.