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 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.
    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.
Related concepts
Visualizing and editing a physical data model

Feedback