EPUB | CHM | PDF

Views

Top Previous Next

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.

Please note:
You can read more about triggers in Using Views topic of MySQL Manual: http://dev.mysql.com/doc/refman/5.1/en/views.html

With Database Designer for MySQL you can:

Create view;

Edit a view;

Manage all views within the diagram.

See also:
Diagram Objects: Creating a View | View Editor | View Manager