Tabular View of Physical Model - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
The tabular view of a physical model displays details of all the selected data tables. Each table displays the attributes and its data type. Other properties of the tables are displayed in the Properties panel.
  1. In a web browser, go to:

    http://server:port/discovery

    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. On the Discovery menu bar, click Model.
    The Logical Model tab is displayed by default.
  3. Select the check box next to the model you want to view.
    Note: You can search for a specific model using the Filter field on the top of the page. It searches the models by the model name.
  4. Click the View Model button .
    Note: You can also go to the tabular view by clicking the Tabular View button on the Edit Physical Model page.
  5. To view the properties of a table, select it, and click the Properties collapsible tab on the right side of the page.
    Note: You cannot modify these properties.

    The Properties panel displays these details:

    Note: The details displayed here are based on the type of the selected data source. For more information, see Connection-specific Details.
    • Columns: Column details, such as the name of the column, the contained data type, its size and whether it is nullable and updatable.
    • Primary Keys: Name of the primary key (if defined) and related column and key sequence
    • Foreign Keys: Name of the foreign key (if defined) and related column and table name