Views are stored queries that act as a virtual table.
| Title | Description |
|---|---|
| Creating & Using Views | A tutorial on creating and using views. |
| CREATE VIEW | Create or replace a view. |
| ALTER VIEW | Change a view definition. |
| DROP VIEW | Removes one or more views. |
| SHOW CREATE VIEW | Show the CREATE VIEW statement that created a view |
| Inserting and Updating with Views | Views can be used for inserting or updating with certain limitations. |
| RENAME TABLE | Change a table's name. |
| View Algorithms | Optional ALGORITHM clause when creating views |
| Information Schema VIEWS Table | Information about views |
| SHOW TABLES | List of non-temporary tables, views or sequences. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/views/