Skip to content

Glossary: SQL Beyond the Basics

View

Also written: views, CREATE VIEW

A query saved in the database under a name, which you select from as if it were a table. It stores no data and always shows current results, like the order_summary view.

Where the book teaches it

Related terms

Materialized viewCTE (common table expression)