Adding Tables in a Minischema

You can modify a minischema by adding tables to it from a physical source.

You can follow the dialog box-based procedure in Adding or Removing Tables in a Minischema or use the process below.

  To add tables to a minischema:

  1. If not already opened, open the minischema (see Opening a Minischema).

  2. In the Source Navigator, select the Data Sources tab, and then expand the data source connection name from which you want to add a table.

    A list is displayed of the physical table objects that you added to the data source during data source creation and any tables you added subsequently.

  3. Select the table you want to add and drag it into the minischema work area.

    A join will be made automatically if it is present in the physical data source.

    Note:

    You cannot add the same physical table to the minischema more than once.

  4. Repeat step 3 for all physical tables that you want to add to the minischema.

  5. To save your changes, right-click in the minischema work area and select Save Minischema.