).
All tables do not have to be in the same state when multi-selected
and both Hide and Show Columns
menu options appear when they are not all in the same state.Use the Warehouse Schema Model window to add join relationships between non-keyed columns in tables that are displayed on the canvas. You can join any two columns (multi-column joins are not allowed).
Note: Existing primary and foreign key joins are automatically joined when you select the tables and click Autojoin. (The lines are drawn in green until you save your work.) Any additional non-keyed column joins that you add are shown in black. When you click Save, the joins relationships are saved as part of the schema.
Use the View menu to Hide Columns
or Show Columns on tables shown on the canvas. Primary keys
are shown graphically with an icon ().
All tables do not have to be in the same state when multi-selected
and both Hide and Show Columns
menu options appear when they are not all in the same state.
To add a join relationship between columns:
Ensure that there are at least two tables defined on the canvas.
Click the join tool on the pallate, and then click the column in the first table, holding the mouse button down. Move the cursor to the column of the second table to establish the join relationship. Click the save icon on the toolbar or select Warehouse schema --> Save to save the join. The join relationship is immediately added to the schema.
Related information
