Views
Views are stored queries that act as a virtual table.
-
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
Shows the CREATE VIEW statement that creates 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.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.