How to show the Schema Owner in the Model Explorer

To view the owners in a physical display, you simply have to open the Diagram Editor for the diagram in question and select the "Display Owner" option on the table tab. 

The result will be a display similar to the following...

Finally, if you wish to view tables by owner in one of the editors, you can do so in several ways depending on what you are trying to accomplish.

You have options to "filter" tables in the Table Editor (just type as much of the owner name as desired in the "filter text" area.

The Subject Area Editor provides options for displaying and sorting by owner name.

The Bulk Editor allows you to select, filter, sort and modify the model metadata (including owner/schema) to accomplish many different tasks ...

Lastly, there is a feature that allows users to modify the information displayed in the model explorer.  An example of this is to prepend the owner name to the table names displayed. Unfortunately, that feature is not working properly in r9.x.

The fix:  Customize the Model Explorer Display of Physical Object Names

A template file is provided with erwin Data Modeler that lets you customize the display of physical object names in the Model Explorer. By using macros in the template file, you can override the default display of selected object names. 

The file Physical Names.ont (attached to this article at the bottom) includes display options for the physical model. For a 32-bit version, it is automatically installed to the C:\Program Files\erwin\Data Modeler r9\BackupFiles\Templates folder. Comments and a sample macro are provided in the file to customize the display of the parent/child relationship phrase in the Model Explorer. By default, the display is formatted to include the elements <parent name> <relationship name> <child name>.

You can modify the macro to exclude one of the elements.  For example, if you wanted to exclude the parent name in the display you can add or edit entries in this file to customize the display in Model Explorer.  These entries are optional; if there is no macro specified for an object type, then Model Explorer displays the object's name.

Please follow these steps to customize the display of physical object names in the Model Explorer:

1. Go to the <install folder>\erwin\Data Modeler r9\BackupFiles\Templates folder and open the Physical Names.ont file in a text editor.
2. Add new entries or edit existing entries for each physical object that you want to customize.
3. Click Save on the File menu, then click Exit on the File menu when you are done editing the file.