- 20.3.3 Using the MySQL Visual Studio Plugin
- 20.3.3.1 Editing Tables
- 20.3.3.2 Editing Table Data
- 20.3.3.3 Editing Views
- 20.3.3.4 Editing Stored Procedures and Functions
- 20.3.3.5 Editing Triggers
- 20.3.3.6 Editing User Defined Functions (UDF)
- 20.3.3.7 Dropping database objects
- 20.3.3.8 Cloning database objects
To create a new view, right click the Views node under the connection node in Server Explorer. From the nodes context menu, choose the Create View command. This command opens the SQL Editor.
To modify an existing view, double click on a node of the view you wish to modify, or right click on this node and choose the Alter View command from a context menu. Either of the commands opens the SQL Editor.
To create or alter the view definition using SQL Editor, type the appropriate SQL statement in the SQL Editor.
Note
You should enter only the defining statement itself, without
the CREATE VIEW AS preface.
All other view properties can be set in the Properties window. These properties are:
Algorithm
Check Option
Definer
Name
Security Type
Some of these properties can have arbitrary text values, others accept values from a predefined set.
The properties Is Updatable, Schema and Server are readonly.
To save changes you have made, use either Save or Save All buttons of the Visual Studio main toolbar, or just press Ctrl+S. A confirmation dialog will confirm whether you want the changes saved to the database.
User Comments
Add your own comment.