Views

Views (updatable) are being implemented in the 5.0 version of MySQL Server. They are already 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).

The list of database views can be viewed and modified at the Views Page of the Main Profile Window.

You can create a new view in several ways:

1. Create a new view in Design View by double-clicking at the Create view in design view item on the Views profile window page.
2. Create a new table using the View Wizard by double-clicking at the Create view by using wizard item on the Views profile window page.

To open the existing view for viewing or modifying data, simply double-click at its name on the Views profile window page.

To change the view structure select its name at the Views page and click the Design button on the toolbar or in the popup menu. This opens the View Designer, allowing you to select view tables, columns, conditions, etc.

To delete a view from the database, select its name at the Views page and click the Delete button on the toolbar or in the popup menu.

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.