The AS query and EDIT SQL tabs allow you to create a view using the query builder or by editing an SQL SELECT.
- Database
-
A combo box with databases attached. Select one and the table will be created in this schema.
- View Name
Name of new view. It must be nonempty.
- AS query tab
-
This opens the query builder where you can create a view using a CREATE VIEW name AS SELECT ... statement.
- Edit SQL tab
-
You can write any SQL CREATE VIEW statement here: the first line containing 'CREATE VIEW "schemaname"."tablename" AS' is not editable except by changing the Database name or Table 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.
- Create
-
Press this button to create the view. The Create button is only enabled if the new view has a nonempty name. The result of this operation is shown in the text area below, which will expand if it needs to contain a long error message.