Wählen Sie Ihren SQL-Server:
Neuheiten abonnieren

 Partners
 Testimonials
Mario Figueiredo: "I can safely forget all I know about SQL when using SQLite Maestro. It is that easy and intuitive to use. It is also nicely drawn with an easy and appealing interface that makes the sometimes boring tasks of database maintenance and administration more endurable.
The decision to support the non-commercial use of your software with a lower price is absolutely worth mentioning. For that alone, I thank you. For everything else, I say keep up the good work".
Ephraim Stevens : "I just wanted to re-iterate what a wonderful job your developers have done and what a wonderful product SQLite Maestro is. There are so many great things to say about it that I won't go into here. It saves an end user a lot of time on repetitive tasks. Keep up the excellent work over there".
More
Add your opinion
 Customers
|
SQLite Maestro online Help
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). |
| • | Specify the abilities to be available on working with the view data. By default the views are generated for inserting, updating, and deleting of table data. |
| • | Adjust the name templates of views and corresponding triggers. |
| • | 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. |

|
 Company news 
May 5, 2021
New version introduces new database encryption algorithms, support for generated columns, support for renaming and dropping columns using ALTER TABLE statement, and some other enhancements.
Nov 14, 2016
New version introduces support for FTS5 extension and expression-based indexes, new encryption algorithms in data grids, updated data export and data import tools, and some other useful things.
Jan 12, 2015
New version comes with support of user authentication and management, read-only database connections, colored tabs, and some other new features.
 Feature of the day
Sie konnen verschiedene Datenbankobjekten in Objekt Manager von SQLite Maestro auswahlen, um weiter mit allen von ihnen zu operieren.
Dieses Feature von SQLite Maestro ermoglicht SELECT Abfragen als visuelle Diagramme zu bilden und bearbeiten.
|
|