Views

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).

You can think of a view as virtual table.  It does not physically exist, but works like a real table.  Usually it is created by a query joining one or more tables.

With Database Designer for MySQL you can:

• Creating a view, construct it using graphical designer
• Edit a view
• Manage all view within the diagram.

Diagram Objects: Creating a View | View Editor | View Manager | View Designer

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