The options menu allows users to add tables, notes and texts to the diagram, and create or modify table relationships. It has a “View” sub-menu to let users to turn on rulers, grid and page breaks, and a “Show View” sub-menu to display the outline view and the properties view.
Choose the “Add Tables…” menu option will display the “Add Tables” dialog box.
Select a database in this page, then, click the “Next” button.
Choose tables, views and synonyms in the “Available database objects” list box and move them to the “Selected database objects” list box. Then, click the “Finish” button to add them to the diagram. These database objects will be stacked together at the top-left corner of the diagram. You can click the “Arrange All” toolbar button to layout them properly.
You can also add notes and texts using the options menu. After choose the “Add Note” or “Add Text” option, a note or text object will be added at the top-left corner of the diagram. You can drag them to a proper place, and double-click the note or text object to start editing them.
The “New Table Relationship…” and “Edit Table Relationship…” menu options invoke the wizard dialog box described in Section "Define master-detail relationships" to create or edit master detail relationships between tables. The difference here is that the wizard will only allow users to choose master and detail tables that are displayed in the diagram.
Note that the foreign key relationships are not editable. Therefore, if you click a foreign key connection, and select “Edit Table Relationship…” menu option, the wizard will only display read-only pages that allow you to see all the related key columns.