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: With Database Designer for MySQL you can: Create view; Edit a view; Manage all views within the diagram. See also: |