In the Data Source Explorer, you can navigate through the
available databases and explore schemas, tables, or other database
objects.
To explore the tables of a DB2® database
schema in an overview diagram, follow these steps:
- In the Data Source Explorer, connect to a DB2 database, for example, DWESAMP, and navigate
to the Schemas folder.
- Expand the Schemas folder, right-click a schema, for example,
BANK, and select Add to Overview Diagram from
the popup menu.
- In the Overview Diagram Selection dialog, the selected
schema is preselected. Accept the default values and click OK.
The overview diagram is displayed. Relationships between
tables are indicated by lines that connect the tables.
To display the properties of the tables, follow these steps:
- In the Data Source Explorer, select a schema, for example, BANK,
expand the Tables folder, and select the table that you want to explore,
for example, BANKCUSTOMERS.
The properties of the table are displayed
in the Properties View. The following properties are provided:
- General
- Distribution Key
- Data Partitions
- Table Spaces
- Dimensions
- Columns
- Relationships
- Documentation
- To browse the columns of the selected table, click Columns on
the Properties page.
- To browse the properties of a particular column in the selected
table, for example, BANKCUSTOMERS, expand the Columns folder in the
Data Source Explorer and click a column, for example, CLIENT_ID.