©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Editing MySQL and MariaDB views

Editing MySQL and MariaDB views

Views Editing MySQL views is part of the view management
Edit MySQL views

Module for editing MySQL views:

Views are displayed formatted in the SQL editor.

You can search and mark in the SQL editor.

SELECT statement can be executed and parsed.

Data output, structure view, archiving and download are available.

View structure Shows the table structure of the view result.
Data result of the view Displays the data result of the view as a table.
SELECT test Runs the view's SELECT statement as a test and displays the data result.
Explain SELECT Executes EXPLAIN SELECT of the view as a test and outputs the analysis result.
Save changes Saves the changes to the view to the database. A security copy of the previous version is stored in the script archive.
Save to script archive Saves the view in the script archive.
Download view creation Download the view creation script.
View permisssions View and edit the permissions of the view.
Delete View Deletes view from database.
Searching in SQL Editor:
Search SQL text Find and highlight terms in the SQL Editor.
Delete markers Delete search markers.
Jump to previous marker Jump to previous marker.
Jump to next marker Jump to next marker.
Views head:
Name: Name of the view.
Column names: Specification of the column names for the query result of the view.
Creator: Creator of the view.
Algorithm: Choice of algorithm.
SQL security: Choice of SQL security.
Check option: Selection of the check option.
MySQL - Views menu

Labeled menu by double-clicking title bar.

Learn more about editing SQL scripts: SQL editor
More information about MySQL views can be found here: mysql.com und mariadb.com
Updated: 2023-09-16ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2023 Heino Cunze-Fischer