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 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:

  1. Right-click a model object in a physical data model, and click Add Data Object.
  2. 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.
  3. Type a name for the new object in the Data Project Explorer.
  4. Save the physical data model.

Results

The new objects are displayed in the Data Project Explorer.

Feedback