Views

Learn to use views in MariaDB Server. This section explains how to create virtual tables from query results, simplifying complex queries and enhancing data security and abstraction.

ALTER VIEW

Documentation for the ALTER VIEW statement, which is used to modify an existing view's definition without dropping and recreating it.

CREATE VIEW

Complete CREATE VIEW reference: OR REPLACE/IF NOT EXISTS, ALGORITHM=MERGE|TEMPTABLE|UNDEFINED, DEFINER/CURRENT_USER, and SQL SECURITY DEFINER|INVOKER.

DROP VIEW

Explains how to use the DROP VIEW statement to remove one or more views from the database, including required privileges.

Information Schema VIEWS Table

Describes the VIEWS table in the Information Schema, which provides metadata about all views in the database, such as definition and check options.

Inserting and Updating with Views

Covers the conditions under which a view is updatable, allowing INSERT, UPDATE, and DELETE operations to modify the underlying base tables.

View Algorithms

Learn about the different algorithms (MERGE, TEMPTABLE, UNDEFINED) MariaDB uses to process views and how they impact performance and updatability.

_{This page is licensed: CC BY-SA / Gnu FDL}