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 Data Source Navigator,under the data source connection name, 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.

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

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