Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Prithwi Thakuria: "I have been in the database field for eons. This is one the best suite of tools I have found in terms of cost, functionality and performance. Ever since we bought this array of products, life with databases have been a breeze and the productivity has soared immensely. Keep up the good work".
Rati Dzidziguri: "I'm working on development of ERP and CRM software and during the process of creation of those products I have tried lots of solutions by the only solution I would call as an user friendly professional and with many other epithets is MySQL Maestro and all Maestro toolkits".

More

Add your opinion

SQL Maestro for MySQL online help

Prev Return to chapter overview Next

Generation of updatable views

To generate updatable view,

 

select the Object | Generate updatable views... main menu item (to create views for several tables) or use the corresponding popup menu item of the table's node at the Explorer tree (to create a view for one table).
Specify tables the views will be created for (in case of several tables).Select the action to perform after the generation. The created definitions can be copied to Clipboard, saved to a file, sent to SQL Script Editor or executed immediately.

 



Prev Return to chapter overview Next