Tablespace and Storage Properties

You can modify an object's properties from its property sheet. To open a tablespace or storage property sheet, double-click its Browser entry.

Property

Description

Name

Specifies the name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users.

Code

Specifies the technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces.

Comment

Specifies a descriptive label for the item.

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined.

Cost tab

The Cost tab is available if data lifecycle modeling (see Lifecycles (PDM)) is supported by your DBMS.

Property

Description

Cost (per GB)

Specifies the cost per GB of the storage represented by the tablespace

Currency

Displays the currency to use for the cost per GB of storage. You can change the currency by selecting Tools > Model Options and choosing a currency from the list on the Model Settings page.

Other tabs

The following tabs are also available:


  • Physical Options - lists all the physical options that can be applied to the tablespace or storage (see Physical Options).

  • Physical Options (Common) - lists the most commonly used physical options that can be applied to the tablespace or storage.

Note: For detailed information about tablespace and storage options for a particular DBMS, see its reference manual.