Editing a view¶

To edit a view:

Select the view in the tree panel.
Go to the Design tab, where you can change the view's name and the SQL of its AS clause.

View triggers¶

A view is read-only by nature, but you can attach INSTEAD OF triggers to it so that inserts, updates, or deletes against the view are redirected to the underlying tables. Manage them on the Triggers sub-tab.

The Triggers sub-tab of a view

To add a trigger: click Add, fill in the trigger's name and parameters, and click OK.
To modify a trigger: select it, click Modify, make your changes, and click OK.
To delete a trigger: select it and click Delete.

Applying changes¶

Click Apply to save your changes, or Cancel to discard them. Applying replaces the old view definition with the new one.

Note

SQLite Expert wraps the operation in a transaction. If an error occurs it is rolled back automatically, so you can correct the problem and try again.

See also: Creating a view · Editing table triggers