Change Which Properties Appear in a Database Diagram

When you show a database table in column properties view, some but not all of that table’s property columns are visible. You can customize this view by choosing whether to hide or show each property column in a database table.

Note   When you change which properties appear, you change only the displayed properties for that table in that database diagram.

Hide a property column

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table whose property column you want to hide. If necessary, right-click the table, and then click Column Properties or Custom View.
3. Position the pointer along the right border of the column header for the column that you want to hide. The cursor changes from an arrow to a splitter pointer .
4. Drag the column border to the left until it meets the column’s left border.
5. Release the mouse button.

Show a property column that is hidden

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, select the table whose property column you want to show. If necessary, right-click the table, and then click Column Properties or Custom View.
3. Position the pointer along the right border of the previous column’s header. The cursor changes from an arrow to a splitter pointer .
4. Double-click the splitter pointer. The hidden column resizes to fit the widest entry.

   Note   You can also set which column properties you want to display for database tables in a database diagram by using the Custom view command on the Table submenu of the View menu.