When writing SQL for an MV there should be a schema/table/column tree pane - ideally it would include drag-n-drop functionality, but at a minimum it would allow an author to check column spelling, format, and case without having to close ( and losing the existing text entered ) the window.
Ditto an execute button or even a validate option integrated in the edit window so you don't have to go through the "OK, OK, wait, error" routine.
Pictured: edit window -
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.