	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

Manage and edit MySQL and MariaDB views

The view editing module can be reached by selecting Views of the database in the main menu

MySQL - Managing and editing MySQL views

Module for managing and editing MySQL views (views) in databases:

Views can be filtered alphabetically or by search.

Views can be selected for export or actions.

The list can be sorted by clicking on the field headings of the view list.

A backup archive is available.

There are also modules for editing the views and for outputting data.

	Reloads views menu and list.
	Displays the menu for alphabetical selection of views.
	Starts form for creating new views.

	Searching in view names, with %... inside the view names.
	Searching in SQL definitions for views.
	Searching for tables and table columns in views.

	Displays the action module for selected views (Export, Save, Delete).
	Shows the export module for all views.
	Saves the creation scripts of all views to the archive.
	Shows the script archive.

Buttons in views list:

Data:	Displays data of view with SQL statement.
Edit:	Opens the form for editing the view.
Script:	Shows the creation script of the view in the SQL editor.
Download:	Downloads the view creation script.
Delete:	Deletes the view.

Icons in the views menu:

	Displays data of the view with SQL statement.
	Opens the data wizard for the view.
	Displays the view creation script in the SQL editor.
	Displays the table structure of the view.
	Opens the form for editing the table.

Export and action module for selected views.

Creator:	The creator of the view is specified in the creation script.
Security type:	The security type of the view is specified in the creation script.
Algorithm:	The algorithm of the view is specified in the creation script.
Check option:	The check option of the view is specified in the creation script.
Database:	The view's database is specified in the creation script.

CREATE:	Creation option for view creation scripts: View is created.
CREATE IF NOT EXISTS:	Create a view if it doesn't exist.
DROP & CREATE:	View is deleted and recreated.
CREATE OR REPLACE:	View is created or replaced. For MariaDB databases only.
Table definition:	A table creation (CREATE TABLE) is created for the views.
View definition:	A view creation (CREATE VIEW) is created for the views.

Filename:	Filename for export files.
Delimiter:	View program codes are enclosed in delimiters.
Append file name to individual files:	The specified file name is also included in the individual file export.
Database name in file names:	The database name is included in the file names.
Output individual files with delimiters:	When exporting views to individual files, the program code is enclosed in delimiters.
Unformatted code:	The creation scripts for views are not formatted by the MyWAY SQL Manager.
GZIP compression:	Files are exported or backed up GZip compressed.

Show selected views as text:	The export file is shown as text in the SQL editor.
Download selected views in one file:	Only one export file will be downloaded with the specified name containing all scripts.
Download selected views as individual files:	A separate export file is downloaded for each view.

Save selected views:	Views are saved in the script archive of the MyWAY SQL Manager.
Delete selected views:	Views are deleted from the MySQL server (DROP).
Invert selection:	Inverts the selection markers.

Export and backup module for all views of the MySQL database.

Creator:	The creator of the view is specified in the creation script.
Security type:	The security type of the view is specified in the creation script.
Algorithm:	The algorithm of the view is specified in the creation script.
Check option:	The check option of the view is specified in the creation script.
Database:	The view's database is specified in the creation script.

CREATE:	Creation option for view creation scripts: View is created.
CREATE IF NOT EXISTS:	Create a view if it doesn't exist.
DROP & CREATE:	View is deleted and recreated.
CREATE OR REPLACE:	View is created or replaced. For MariaDB databases only.
Table definition:	A table creation (CREATE TABLE) is created for the views.
View definition:	A view creation (CREATE VIEW) is created for the views.

Filename:	Filename for export files.
Delimiter:	View program codes are enclosed in delimiters.
Append file name to individual files:	The specified file name is also included in the individual file export.
Database name in file names:	The database name is included in the file names.
Output individual files with delimiters:	When exporting views to individual files, the program code is enclosed in delimiters.
Unformatted code:	The creation scripts for views are not formatted by the MyWAY SQL Manager.
GZIP compression:	Files are exported or backed up GZip compressed.

Show all views as text:	The export file is shown as text in the SQL editor.
Download all views in one file:	Only one export file will be downloaded with the specified name containing all scripts.
Download all views as individual files:	A separate export file is downloaded for each view.

Labeled menu by double-clicking title bar.

MySQL and MariaDB views are virtual tables derived from the result of a query. They provide a way to present data stored in one or more tables in a structured and customized way without changing the underlying tables.

A view is based on a SELECT statement that retrieves data from one or more tables or other views. The SELECT statement serves as the definition of the view. You do not store any data yourself. They act as virtual tables that display the result of the underlying query.

Views can be used to abstract complex or commonly used queries, making it easier to query and manipulate the data, and can be used to control access to specific columns or rows of a table. By granting access to a view rather than the underlying table, you can limit the data that users can view or modify.

Views can simplify data retrieval by encapsulating complex joins, aggregations, or calculations in a single view. In some cases, views may be updatable, allowing changes to be made through the view and the changes reflected in the underlying tables.

Views provide a convenient way to organize and present data in a controlled manner, improving data abstraction and security, and simplifying complex queries. They can be queried like normal tables and any changes made to the underlying tables are reflected in the view.

More information about MySQL views can be found here: mysql.com and mariadb.com

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer