Using the Schema Viewer

The schema browser

SchemaTablesView.png

The schema browser (top) provides an easy way to view the schema on the remote server. The bottom half of the schema viewer shows details about the item selected in the browser. The following table details what appears in each column of the browser:

Column Contents
1 Databases
The name for these varies by the type of server, but these are also known as schemas, tablespaces, or owners.
2 Tables
This list includes tables, views, and Oracle synonyms. When an item is selected, the detail view displays the appropriate CREATE statement.
3 Table Items
This column displays a list of items associated with the parent table. All of these items are not available for every supported server type.
Columns
When selected the table columns will be listed in the browser's fourth row. More details about the columns will be displayed below. Selecting a column name in the browser will select that column in the details table at the bottom of the window. Columns may be edited.
Indexes
When selected a list of indexes are displayed in the fourth column and details about those indexes are displayed belown.
Foreign Keys
A list of foreign keys will be displayed when this browser column is selected. Foreign Keys are not support for MySQL.
Relationships
Displays a list of user-defined relationships linking this table with other tables.

Related topics

Table of Contents