Creating a View

There is no GUI dialog for creating a view, but you can:

1. Use the Query Builder to create the SELECT statement graphically,
2. Load the generated SELECT statement into the SQL Editor by clicking the corresponding button in the toolbar,
3. Add CREATE VIEW name AS before the SELECT statement,
4. Execute the CREATE VIEW statement.