Adding objects to a physical data model from the Data Project Explorer

Use the menu actions in the Data Project Explorer to add physical data objects to a physical data model.
Before you add data objects to a physical data model, you must open a physical data model in the physical data model editor.

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:

  1. Right-click a model object in a physical data model, and click Add Data Object.
  2. 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.
  3. Type a name for the new object in the Data Project Explorer.
  4. Save the physical data model.
The new objects are displayed in the Data Project Explorer.
Related concepts
Visualizing and editing a physical data model
Related information
Data object properties
Alias properties
Check constraint properties
Column properties
Database instance properties
Distinct user-defined type properties
Index properties
MQT properties
Relationship properties
Schema properties
Sequence properties
Stored procedure properties
Structured user-defined types properties
Table properties
Trigger properties
User-defined function properties
Unique constraint properties
View properties
Synonym properties

Feedback