> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/views.md).

# Views

{% columns %}
{% column %}
{% content-ref url="/pages/TYmDM1OmOrS1lHMHnx2Y" %}
[ALTER VIEW](/docs/server/server-usage/views/alter-view.md)
{% endcontent-ref %}
{% endcolumn %}

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

{% columns %}
{% column %}
{% content-ref url="/pages/kg4mTCOVxzCTEUYiOph5" %}
[CREATE VIEW](/docs/server/server-usage/views/create-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete CREATE VIEW reference: OR REPLACE/IF NOT EXISTS, ALGORITHM=MERGE|TEMPTABLE|UNDEFINED, DEFINER/CURRENT\_USER, and SQL SECURITY DEFINER|INVOKER.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/zxsiHTOhoQbkmAe3KaT4" %}
[DROP VIEW](/docs/server/server-usage/views/drop-view.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explains how to use the DROP VIEW statement to remove one or more views from the database, including required privileges.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/nkSUCWPfeKZCfbAVVjhh" %}
[Information Schema VIEWS Table](/docs/server/server-usage/views/information-schema-views-table.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Describes the VIEWS table in the Information Schema, which provides metadata about all views in the database, such as definition and check options.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/I3LQdImqIhlW9EKJVILA" %}
[Inserting and Updating with Views](/docs/server/server-usage/views/inserting-and-updating-with-views.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Covers the conditions under which a view is updatable, allowing INSERT, UPDATE, and DELETE operations to modify the underlying base tables.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/uoj7y7n3VkLlLgTc0KXr" %}
[View Algorithms](/docs/server/server-usage/views/view-algorithms.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about the different algorithms (MERGE, TEMPTABLE, UNDEFINED) MariaDB uses to process views and how they impact performance and updatability.
{% endcolumn %}
{% endcolumns %}