Working with the Cross Schema Diagram
The Cross Schema Diagram tab displays every schema currently included in the model. You can:
• View the resources (schemas and views) and the tables in each schema.
• View all relationships, both within schemas and between schemas.
• Create relationships and edit existing relationships.
To work with the Cross Schema Diagram
1. Open a model.
2. Select the Cross Schema Diagram tab at the bottom of the window.
Discovery displays a diagram that shows all schemas that are currently in the model. In this example, the two schemas are shown as blue boxes.
3. Optionally: select a schema, right-click to display the pop-up menu, and choose one of the options.
Note: The diamond indicates the current selection.
• Show Tables with Cross Schema Relationships—Displays only relationships between the selected schema and other schemas in the model.
• Show Tables with Relationships—Displays all relationships both within the selected schema and between it and other schemas in the model.
Double-clicking any table shows its key columns. Double-clicking again displays all columns.
You can also do most of the same things in the Cross Schema Diagram that you can do in the model Diagram tab including: