Other Object Model Options

To set model options for tables and views, indexes, join indexes, procedures, sequences, triggers, and database packages select Start of the navigation path Tools Next navigation step Model Options End of the navigation path , and select the appropriate sub-category under Model Settings.

You can set the following options for these objects:

Option	Function
Default owner	Specifies a default owner for the specified object from the list of users (see Creating a User, Group, or Role). To create a user, click on the ellipsis button to open the List of Users, and click the Add a Row tool. If the user specified is subsequently deleted, this option (and the ownership of all associated objects) will be reset to none.
Ignore identifying owner	[tables and views] Specifies that the owner of a table or view is ignored for identification purposes. Since, by default, both the name/code and the owner are considered during a uniqueness check, this option enables you to enforce distinct names for these objects. For example, if a model contains a table called "Table_1", which belongs to User_1, and another table, also called "Table_1", which belongs to User_2, it will, by default, pass a uniqueness check because of the different owners.
Rebuild automatically triggers	[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 If this option is not selected, you can manually instruct PowerDesigner to rebuild triggers at any time by selecting Tools Rebuild Objects Rebuild Triggers .

Option

Function

Default owner

Specifies a default owner for the specified object from the list of users (see Creating a User, Group, or Role). To create a user, click on the ellipsis button to open the List of Users, and click the Add a Row tool.

If the user specified is subsequently deleted, this option (and the ownership of all associated objects) will be reset to none.

Ignore identifying owner

[tables and views] Specifies that the owner of a table or view is ignored for identification purposes. Since, by default, both the name/code and the owner are considered during a uniqueness check, this option enables you to enforce distinct names for these objects.

For example, if a model contains a table called "Table_1", which belongs to User_1, and another table, also called "Table_1", which belongs to User_2, it will, by default, pass a uniqueness check because of the different owners.

Rebuild automatically triggers

[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

If this option is not selected, you can manually instruct PowerDesigner to rebuild triggers at any time by selecting Start of the navigation path Tools Next navigation step Rebuild Objects Rebuild Triggers End of the navigation path .