Schema design: adding tables

A Table Browser a component available in the Universe Designer which allows the designer to select tables from the target database (it shows a list) and place them on a structure pane, which shows a visual representation of the physical data structure to which the universe is mapped.
The Table Browser is an independent window that shows a tree view of the tables, views and columns in the database, which can be easily inserted into the designed schema.

The Table Browser can be invoked using one of the following methods:

  • Click the Table Browser button.
  • Select Insert Tables from the menu.
  • Double-click the background area of the structure pane.
  • Right-click the Structure pane and choose Tables from the drop-down menu.
    Single tables or multiple tables simultaneously can be inserted into the schema (with drag and drop, an insert button or just double-clicking a table).

    The Table Browser can be also used to preview the source data in a table or a column of an underlying database. To do this, expand a table in the Table Browser, right-click a column or the entire table and click View Table Values.

    To get a better view of the tables in the structure pane, click the Arrange Tables button to arrange tables horizontally