Exploring the database structure.
Upon opening AdventureWorks we get this display:
The tree view at the left shows us that the tables in this database are grouped in 6 schemas.
Clicking the arrow left of 'Purchasing' results in:
Notice that although there are 7 tables in the Purchasing schema, just 3 are displayed in the tree on the left side. DataRoamer knows that these 3 are the "top level" tables in this schema.
Clicking the icon left of 'PurchaseOrderHeader' results in the following display, showing tables related to PurchaseOrderHeader on the left side and showing details about this table on the right.
PurchaseOrderDetail (under PurchaseOrderHeader on the left side above) is one of the 'Purchasing' tables which wasn't displayed at the outermost level. It is a child of PurchaseOrderHeader and is only displayed when that is expanded.
There's an option in DataRoamer's 'View' menu which can be used to display all tables at the first level instead of just top level tables. Here's how the top level of the Purchasing schema looks with that option selected.
