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