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 -
... View more