Editing views

A view is a saved SELECT query that behaves like a read-only table: each time you open it, SQLite runs the underlying query and shows you the result. Views are ideal for packaging up a complex or frequently used query — a join across several tables, for instance — under a single, simple name.

In this section

• Creating a view
• Editing a view
• Deleting a view or a group of views