> 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

- [ALTER VIEW](https://mariadb.com/docs/server/server-usage/views/alter-view.md): Documentation for the ALTER VIEW statement, which is used to modify an existing view's definition without dropping and recreating it.
- [CREATE VIEW](https://mariadb.com/docs/server/server-usage/views/create-view.md): Complete CREATE VIEW reference: OR REPLACE/IF NOT EXISTS, ALGORITHM=MERGE|TEMPTABLE|UNDEFINED, DEFINER/CURRENT\_USER, and SQL SECURITY DEFINER|INVOKER.
- [DROP VIEW](https://mariadb.com/docs/server/server-usage/views/drop-view.md): Explains how to use the DROP VIEW statement to remove one or more views from the database, including required privileges.
- [Information Schema VIEWS Table](https://mariadb.com/docs/server/server-usage/views/information-schema-views-table.md): 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](https://mariadb.com/docs/server/server-usage/views/inserting-and-updating-with-views.md): Covers the conditions under which a view is updatable, allowing INSERT, UPDATE, and DELETE operations to modify the underlying base tables.
- [View Algorithms](https://mariadb.com/docs/server/server-usage/views/view-algorithms.md): Learn about the different algorithms (MERGE, TEMPTABLE, UNDEFINED) MariaDB uses to process views and how they impact performance and updatability.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://mariadb.com/docs/server/server-usage/views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.