3.8

View Query

A SELECT statement that creates a virtual table (view) from an underlying SELECT statement.

CREATE VIEW

A SQL command that creates a view table and specifies the view name and query.

Materialized View

A view for which data is stored at all times, requiring refresh when the base tables change.

Base Table

The original tables from which views are created; data is stored in base tables, not views.

Database Performance

Refers to the efficiency and speed of database operations; using materialized views can enhance performance.

View Reference

A feature that allows a view query to reference another view table.

Hiding Data in Views

Views can be utilized to conceal rows and columns from database users.

Primary Key

A unique identifier for records in a table; must not be null and is essential for maintaining data integrity.

Join View

A view that combines data from multiple tables through join operations; often results in undefined behavior upon deletion.

WITH CHECK OPTION

A clause that prevents DML operations that would violate view constraints, generating an error message if violated.