

See The Index Properties Dialog.Īdd Synonym: Opens the Synonym Properties Dialog. See The Sequence Properties Dialog.Īdd Index: Opens the Index Properties Dialog. To create or edit a sequence for a selected schema. See The Table Properties Dialog andĪdd/Edit Sequence: Opens the Sequence Properties Dialog. New object by using an existing one for the initial content. To edit an existing object (such as a table or view) for a specific schema, or create a See Implied Foreign KeysĮdit, Use as Template: Opens the Table Properties Dialog. The related tables or views are added to the diagram and the star schema layout is applied. Object along with parent and child tables related to the object to the selectedĪdd Object as Star Schema to Diagram: Adds the selected object to the diagram and searches the data dictionary for foreign keys and implied foreign keys related to the object. Alternatively, you can drag and drop an object into a selectedĪdd Object with dependencies to Diagram: Adds the selected The context menu for a table or view consists of:Īdd Object to Diagram: Adds the selected object to the You can also search the contents of a saved diagram. The searchįunctionality is not case-sensitive, retrieves all matching entries, and does notĭescription of "Figure 3-12 Navigator Tab" In a schema, you can search for objects in the Navigator tab by entering a fewĬharacters. Figure 3-12 indicates the important elements in the Navigator tab. You can expand a table to view its columns. Particular schema, if a tables object is selected, the left pane displays all the tables

You can select the schema and object type from the drop-down lists. The Navigator tab lists the objects that are available forĮach schema. Information, see Sharing Diagrams with SQL Developer Data OSDDMW_DIAGRAMS table if a connection is provided. Oracle SQL Developer Data Modeler can import from or export to the When you use Data Modeler for the first time, a Diagrams are stored in the database, in the Database Actions user schema.
