Table and View Model Options

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 tab:

Option	Function
Table: Default owner	Specifies a default owner for the tables in your model from the list of users (see Creating a User). 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 Creating a User). 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.

Option

Function

Table: Default owner

Specifies a default owner for the tables in your model from the list of users (see Creating a User). 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 Creating a User). 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.