Add Views. Add Views to Physical Model To add a new view, click the View button from the toolbar and click anywhere on the canvas. To add an existing view from the Explorer's Model tab, simply drag and drop the selected view from the Model tab to the canvas. Note: If you control-click the view connector, you can choose to add or delete vertices and change its color. The pop-up menu options of the view object in the canvas include: Option Description Design View Edit the view structure in a View Designer. Add Related Objects Add all related tables/views to the selected view. Cut Remove the view from the diagram and put it on the clipboard. Copy Copy the view from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Views Select all views in the diagram. Delete from Diagram / Delete from Diagram and Model Delete a view from the diagram or from both diagram and model. Rename Change the name of the view. Color Change the color of the view. Size to Fit Resize the view automatically to fit its contents. Bring to Front Bring the view to the foreground. Send to Back Move the view to the background. View Designer View Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view definition in SQL Editor directly. Note: The tabs and options in the designer depend on the diagram database type and version you are chosen. Work with View Builder (Available only in Non-Essentials Version) Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. Even if you are familiar with SQL, the convenient and fluent graphical interface makes it easier to create relations and visualize the view. In View Designer, click the button to open the visual View Builder. All database objects are displayed on the left Object pane. Whereas on the middle pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the view, you can view the auto-generated SQL on the right SQL pane. Add Objects to View The first step is to decide which tables and views you need to add to the view. To add tables and views to the view, use one of the following methods: • Drag them from the Object pane to the Diagram pane. • Double-click them on the Object pane. You can set aliases for tables, views and subqueries by double-clicking the obj...
Add Views. Add Views to Physical Model To add a new view, click the View button from the toolbar and click anywhere on the canvas. To add an existing view from the Explorer's Model tab, simply drag and drop the selected view from the Model tab to the canvas. Note: If you right-click the view connector, you can choose to add or delete vertices and change its color, or go to the source view or the target table. The pop-up menu options of the view object in the canvas include: Option Description Design View Edit the view structure in a View Designer. Add Related Objects Add all related tables/views to the selected view. Cut Remove the view from the diagram and put it on the clipboard. Copy Copy the view from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Views Select all views in the diagram. Delete Delete a view from the diagram or from both diagram and model. Rename Change the name of the view. Color Change the color of the view. Size to Fit Resize the view automatically to fit its contents. Bring to Front Bring the view to the foreground. Send to Back Move the view to the background. View Designer View Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view's Definition directly.
Add Views. Add Views to Physical Model To add a new view, click the View button from the toolbar and click anywhere on the canvas. To add an existing view from the Explorer's Model tab, simply drag and drop the selected view from the Model tab to the canvas. Note: If you right-click the view connector, you can choose to add or delete vertices and change its color, or go to the source view or the target table. The pop-up menu options of the view object in the canvas include: Option Description Design View Edit the view structure in a View Designer. Add Related Objects Add all related tables/views to the selected view. Cut Remove the view from the diagram and put it on the clipboard. Copy Copy the view from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Select All Views Select all views in the diagram. Delete from Diagram / Delete from Diagram and Model Delete a view from the diagram or from both diagram and model. Rename Change the name of the view. Color Change the color of the view. Size to Fit Resize the view automatically to fit its contents. Bring to Front Bring the view to the foreground. Send to Back Move the view to the background. View Designer View Designer is the basic Navicat Data Modeler tool for working with views. In View Designer, you can build the views visually using View Builder or edit the view's Definition directly.
