Chapter 3 Building Physical Diagrams


Setting Model Options for Indexes

To set model options for indexes, select Tools→Model Options, and select the Index 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 indexes 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 indexes 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.

 


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