Chapter 2 Physical Data Model Basics

Using a database in a physical option

The databases can be used as a physical option for the tables, columns, views, keys, and indexes of your model.

To use a database in a physical option:

1. Open the property sheet of an object with physical options.
2. Click the Options tab, select the in database (...) option and click the >> button.
3. Select a database from the list below the right pane.
4. Click OK.

When you use the in [<tablespace>] physical option, you associate a predefined tablespace with a database using the following syntax:

DBname.TBSPCname

For example, tablespace CUST_DATA belongs to database myBase. In the following example, table Customer will be created in tablespace CUST_DATA:

You should not define a database together with a tablespace physical option on the same object, this will raise an error during check model.

The database Dependencies tab displays the list of objects that use the current database in their physical options.

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