Devart Forums

Hello,

Is it possible to edit database views with the query builder?

The only way I found up to now is the following:
* Create a new query
* Visually create the view with query builder
* Copy the resulting SQL-Code to clipboard

* Create new View in database
* Paste the copied SQL-String into design-window

When I want to change a view, I have to copy the original SQL-Code to a new query, edit it there and copy it back again.

This is much work and I want to ask if there is a faster way which I do not know.

Best regards,

Hannes

Hello, Hannes!

Try to use Insert SQL or Design SQL commands from the context menu of SQL Editor (Query Text editor) in the view editor.
Insert SQL inserts a new SELECT statement to the view, and if you choose Design SQL, then the SELECT statement from the Query text editor will be opened in Query Builder.

Hello, Alexz!
Thank you very much, this is exatly what I was looking for.
Maybe it was too near to be seen by me....