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.
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 sub menu. 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.