# 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: 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.
