Maintain views visually

[priestriversystems]

Is it possible to create views/modify database views, consisting of multiple tables, visually (such as in the visual editor)?
Thanks!

[alexa]

Yes, this can be performed with dbForge Studio for MySQL.

To create a new view, please do the following:

1. Expand a connection in Database Explorer.
2. Right-click the 'Views' node under the connection.
3. Select 'New View'.

To modify an existing view:

1. Expand a connection in Database Explorer.
2. Expand the 'Views' node under the connection.
3. Right-click a view and select 'Edit View' from the popup menu.

Please also see the 'How To: Work with Views' topic in the product's Help documentation.

[priestriversystems]

Thanks Alexa
I didnt see a way to create a view diagramically.
I did find a workaround - I used the query designer to build the select, and when it worked as I desired I copied the text into a query window and prefixed it with a "create view".

[alexa]

You could also do the following:

1. Expand a connection in Database Explorer.
2. Right-click the 'Views' node under the connection.
3. Select 'New View'. View Editor opens.
4. Right-click in the 'Query Text' field and select 'Insert SQL' from the popup menu.
5. Drug-n-drop the needed tables from the tree onto the diagram and specify conditions in the tabbed editor below the diagram.
6. Click 'OK'.

This could also be performed using the Database Diagram functionality:

1. Select 'File -> New Database Diagram' from the main menu.
2. Right click the diagram and select 'New -> View' from the popup menu.
3. Perform the steps 4-6 above.

[priestriversystems]

Very nice, thanks much! Im still getting used to the tool,and not everything is intuitive yet.

[alexa]

Please let us know if other questions arise.