Views are being implemented in the 5.0 version of MySQL Server. It is 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.

Create a View

To create a view:

1. Click the View button in the main window
   
2. Press the New View button
   
3. You can then create a view, either by typing the select statement in the View Editor, or by building the select statement using the View Builder

Design a View

To design a view:

1. Select the view you want to design.
   
2. Click the Design View button.
   
3. You can then change the content of the View with the View Editor or with the View Builder.
   

Delete a View

To delete a view:

1. Select the view you want to design.
   
2. Click the Delete View button.