Chapter 3 Building Physical Diagrams

Setting Model Options for Triggers

To set model options for triggers, select Tools→Model Options, and select the Trigger sub-category in the left-hand Category pane.


You can set the following options on this page:

Option Function
Table: Default Owner Specifies a default owner for the table triggers in your model from the list of users (see the section "Creating a user" in the Managing Database Users chapter). To create a User, click on the ellipsis button to open the List of Users, and click the Add a Row tool.

If no default user is specified here, then the owner of the parent table is used by default.

If the user specified is subsequently deleted, this option (and the ownership of all associated objects) will be reset to none.
View: Default Owner Specifies a default owner for the view triggers in your model from the list of users (see the section "Creating a user" in the Managing Database Users chapter). To create a User, click on the ellipsis button to open the List of Users, and click the Add a Row tool.

If no default user is specified here, then the owner of the parent view is used by default.

If the user specified is subsequently deleted, this option (and the ownership of all associated objects) will be reset to none.
Rebuild automatically triggers Automatically rebuilds the triggers on the child and parent tables of a reference when you:

  • change the implementation of a reference
  • change the referential integrity rules of a reference implemented by a trigger
  • change the child or parent table of a reference implemented by a trigger (new and old)
  • create or delete a reference implemented by a trigger
  • change the maximum cardinality of the references


Note: If this option is not selected, you can manually instruct PowerDesigner to rebuild triggers at any time by selecting Tools→Rebuild Objects→Rebuild Triggers.

 

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