Database Reference
In-Depth Information
19. Click on
Finish
to import both the tables and then click on
Close
to close the
wizard.
There's more…
Now to tidy things up… With the goal of keeping the model as simple as possible,
hide the objects that users don't need to see. In the model design grid view, you will
see two new tables:
1. Right-click on the new table named
_ProductCategory
and select
Hide
from Client Tools
.
Note
In model design, it's common to rename objects to provide simple and
friendly names for users.
2. Click on the tab for the
Product Category
table and then right-click on the
EnglishProductSubcategory
column header.
3. From the menu, select the option to rename the column and change the
name to
SubcategoryName
.
4. In the lower right-hand corner of the model designer, you can switch between
grid and diagram view. These two small icons aren't labeled but will display a
tooltip when you hover the mouse pointer over them.
5. Click on the Diagram icon to view table relationships in the model.
Search WWH ::
Custom Search