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
Query builder to create/edit database views
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.
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.
