A combo box with databases attached. Select one and the view will be created in this schema.

Name of new view. It must be nonempty.

This opens the Query Builder where you can create a view using a CREATE VIEW name AS SELECT ... statement.

You can write any SQL CREATE VIEW statement here: the first line containing 'CREATE VIEW "schemaname"."viewname" AS' is not editable except by changing the Database name or View Name in the fields above. When you first open this tab, it will make a CREATE VIEW statement from the information in the AS query tab. Every subsequent time you open this tab you will be asked if you want to keep the existing SQL or make it from the information in the AS query tab again.

If you omit the terminating semicolon, sqliteman will add it for you.

Press this button to create the view. The Create button is only enabled if the View name is nonempty and different (ignoring case) from the name of any table or index or other view in the database. The result of this operation is shown in the text area below, which will appear if it is needed and expand if it needs to contain a long error message.

Press this button to close the dialog. You can close the dialog without creating any views or after creating one or several views.