Use the menu actions in the Data Project Explorer to add
physical data objects to a physical data model.
Before you begin
Before you add data objects to a physical data model, you
must open a physical data model in the physical data model editor.
About this task
You can add data objects and dependencies to a physical
data model from the Data Project Explorer, but you cannot add relationships.
To add relationships to a physical data model, use a data diagram.
Procedure
To
add objects to a physical data model from the Data Project Explorer:
- Right-click a model object in a physical data model, and
click .
- Select a data object from the submenu. Some
objects might not be available depending on the database vendor and
version that you are targeting.
Option |
Description |
From any object |
Add a dependency or a URL |
From an alias object |
Add a trigger |
From a database object |
Add a schema, add a storage object such as a table space or
a buffer pool, or add an authorization ID such as a user, role or
group. |
From a column object |
Add a unique constraint |
From an MQT object |
Add an index |
From a schema object |
Add a table, a view, a function table, a function, a stored
procedure, a structured user-defined type, a distinct user-defined
type, a sequence, a synonym, an alias, an MQT, or a nickname. For
DB2 for z/OS models, you can add an auxiliary table. |
From a table object |
Add a column, a check constraint, a unique constraint, a foreign
key, a primary key, an index, or a trigger |
From a view object |
Add a trigger |
The new object is displayed in the Data Project Explorer
under the object that you originally selected.
- Type a name for the new object in the Data Project Explorer.
- Save the physical data model.
Results
The new objects are displayed in the Data Project Explorer.