Tabular View of Physical Model

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.

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.
On the Discovery menu bar, click Model.
The Logical Model tab is displayed by default.
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.
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.
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