Chapter 3 Building Physical Diagrams
To set model options for tables and views, select Tools→Model Options, and select the Table & View 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 tables 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 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 views 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 the user specified is subsequently deleted, this option (and the ownership of all associated objects) will be reset to none. |
| Ignore identifying owner | 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. |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |