Navicat MySQL Migration Toolkit for Windows - Create, Edit, Open and Delete Views

Views (including updatable views) are implemented in MySQL Server 5.0 and available in binary releases from 5.0.1 and up. Views are useful for allowing users to access a set of relations (tables) as if it were a single table, and limiting their access to just that. Views can also be used to restrict access to rows (a subset of a particular table). For access control to columns, you can also use the sophisticated privilege system in MySQL Server.

Just sample click to open an object pane for View. A right-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit, open and delete the selected view.

Create View

To create a new view

Select anywhere on the object pane.
Click the New View from the object pane toolbar.
or
Right-click and select New View from the popup menu.
Edit view properties on the appropriate tabs of the View Designer.

Hint: To create new view you can also right-click the Views node of the navigation pane and select the New View from the popup menu.

To create a new view with the same properties as one of the existing views has (using drag and drop method)

Apply to: current database {same connection}

Select the view(s) for copying in the navigation pane/object pane.

Right-click and drag the chosen view(s) to the target location.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Move here

Cancel

The newly created view(s) will be named as "viewname_copy".

Apply to: different database {same connection}

different database {different connection} (Data Transfer tool will be activated)

Select the view(s) for copying in the object pane.

Drag and drop the chosen view(s) to the target database.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Cancel

To create a new view with modification as one of the existing views

Select the view for modifying in the navigation pane/object pane.
Right-click and select the Design View from the popup menu.
or
Click the Design View from the object pane toolbar.
Modify view properties on the appropriate tabs of the View Designer.
Click Save As.

To create a new view with loading from a SQL file

Select anywhere on the object pane.
Click the New View from the object pane toolbar.
or
Right-click and select New View from the popup menu.
Click Load.

Create View Shortcut

To create a view shortcut

Select the view for editing in the navigation pane/object pane.
Right-click and select Create Open View Shortcut... from the popup menu.
Define the location you wish your shortcut to be saved.

Note: This option is used to provide a convenient way for you to open your view for entering data directly (Grid View/Form View) without activating the main Navicat.

Edit View

To edit the existing view (manage its SQL definition etc)

Select the view for editing in the navigation pane/object pane.
Right-click and select the Design View from the popup menu.
or
Click the Design View from the object pane toolbar.
Edit view properties on the appropriate tabs of the View Designer.

To change the name of the view

Select the view for editing in the navigation pane/object pane.
Right-click and select the Rename from the popup menu.

Open View

To open a view (manage view data)

Select the view for opening in the navigation pane/object pane.
Right-click and select the Open View from the popup menu or simply double-click the view.
or
Click the Open View from the object pane toolbar.

Delete View

To delete a view

Select the view for deleting in the navigation pane/object pane.
Right-click and select the Delete View from the popup menu.
or
Click the Delete View from the object pane toolbar.
Confirm deleting in the dialog window.

Achieve View Information

To achieve a view information (definer, security and DDL, etc)

Select the view in the navigation pane/object pane.
Right-click the selected view and choose View Information from the popup menu.