Chapter 3 Building Physical Diagrams

View triggers

You can define triggers on views for those DBMS that support this feature.

You create a trigger on a view when you want the view to behave like a table; this feature allows you to define a trigger to fire when one or more attributes of a table view column are modified.

The triggers you can define on a view are triggers of type "instead of".

To create a trigger on a view:

1. Open the view property sheet.
2. Click the Triggers tab to display the corresponding page.
3. Click the Add a Row tool to insert a new trigger in the list.
4. Click Apply and click the Properties tool to display the trigger property sheet.
5. Click the Definition tab to display the corresponding page.
   
   The trigger time type is instead of.
6. Select a trigger template in the Trigger Template dropdown listbox and customize the template.
   
   or
   
   Type the template definition directly in the input zone.
7. Click OK.

Copyright (C) 2005. Sybase Inc. All rights reserved.