Physical Modeling › Triggers › Methods to Override Trigger Templates › Table Override Templates › Define the Table Override Triggers Expanded Code

Define the Table Override Triggers Expanded Code

You can use the Expanded tab in the Triggers dialog to display the trigger code as it will appear in the physical schema.

To define the Triggers Expanded SQL code

1. Click Triggers, Table Triggers on the Database menu.

   The Triggers dialog opens.

2. Click the Expanded tab.

   The trigger code as it will appear in the physical schema is displayed for the selected script.

3. Click the Text Editor icon.

   A new dialog where you can edit the code and review the expanded code opens. You can also access the Macro Toolbox and text editing tools in this dialog.

4. Click OK.

   Your changes are saved and the Triggers dialog closes.

   Note: Click Cancel to close the dialog without saving your changes.

You can complete the fields on the General and Code tabs and then optionally select the Comment or UDP tab to add a comment or user defined property.