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

Editing MySQL and MariaDB views

Editing MySQL views is part of the view management

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.

	Shows the table structure of the view result.
	Displays the data result of the view as a table.
	Runs the view's SELECT statement as a test and displays the data result.
	Executes EXPLAIN SELECT of the view as a test and outputs the analysis result.

	Saves the changes to the view to the database. A security copy of the previous version is stored in the script archive.
	Saves the view in the script archive.
	Download the view creation script.
	View and edit the permissions of the view.
	Deletes view from database.

Searching in SQL Editor:

	Find and highlight terms in the SQL Editor.
	Delete search markers.
	Jump to previous 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.

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-16

2020-2024 Heino Cunze-Fischer