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

Subscribe to our newsletter
Partners
Testimonials
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
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".

More

Add your opinion

Customers
Download Buy

SQLite Maestro online Help

Prev  Return to chapter overview Next 

Managing table data

The Data tab displays the table data as a grid (see Data View for details). Use grid’s popup menu to open Data Input Form, to invoke the Export Data, Import Data and Get SQL Dump modules, to set the value of the selected record to NULL or to Now (for Date values).

 

The data grid also provides you with a possibility of displaying data in the master-detail form (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.

 

In case the table contains BLOB columns you can also run BLOB Editor to view and edit the content of these fields.
 

SQLite Maestro allows you to adjust numbering columns in grids.

 


 

Along with data grid SQLite Maestro  provides you with possibility of viewing data as info cards.
 



Prev  Return to chapter overview Next