Add or Edit (Views Menu)

The Add function of the Views Menu creates a new view within the database. A view is a name assigned to a pre-packaged SELECT statement. Once the view is created, it can be used in the FROM clause of another SELECT in place of a table name. You cannot DELETE, INSERT, or UPDATE a view. Views are read-only in SQLite. However, in many cases you can use an INSTEAD OF trigger on the view to accomplish the same thing. The Edit function of the View Menu uses the same View Editor.

View Editor Dialog Items

View Name

Defines the name of the view to be created or being edited. This name must be unique.

SQL

Defines the SQL to be assigned to the view name.

Create or Update

Creates or updates the defined view.

Cancel

Aborts the view creation or modification process and returns to the program.