Chapter 3 Building Physical Diagrams

View property sheet Triggers tab

The Triggers tab is only displayed if your DBMS supports triggers on views.

View triggers can make the view behave like a table. You can define a trigger to fire when one or more attributes of a table view column are modified.

Steps To create a trigger on a view:

  1. Open the view property sheet and click the Triggers tab.
  2. Click the Add a Row tool, and then click the Properties tool to open the property sheet of the newly-created trigger.
  3. Click the Definition tab. The trigger time type will be set to "instead of".
  4. Write a trigger from scratch or select a trigger template. For more details about writing triggers, see the chapter "Building Triggers and Procedures"

 

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