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

Subscribe to our news:
Partners
Testimonials
Ron D.: "I'm still very happy with SQLite Maestro and Data Wizard; makes my HTPC database much easier to manage".
Johnattan Badden, Manager: "The software is easy to work with and most importantly, report management is extremely easy, even for a novice like me! I am able to create and edit my databases with a few clicks and easily maintain them afterwards. I highly recommend SQLite Maestro to educational institutions: it's easy and flexible, it is exactly what can be good for using in schools and colleges".

More

Add your opinion

SQLite Maestro online Help

Prev Return to chapter overview Next

Database Tools

SQLite Maestro provides a number of powerful tools for working with databases.

 

The following tools are available:

 

Creates and executes SQL queries.

 

Builds queries visually.

 

Executes SQL scripts to the database.

 

Allows to edit and execute SQL scripts.

 

Extracts the database objects and data to the SQL script, which can be executed later to reserve the database structure and data.

 

Generates the database HTML or PDF report for structure of selected object in a whole or partially.

 

Allows to create a copy of the database.

 

Displays a content of BLOB fields in different representations.

 

Represents data from a table or a query as a diagram in various ways.

 

Allows to slice and dice information efficiently according your business rules.

 

Prepares data for reading, viewing, and printing in a polished look.

 

Allows to represent database tables and relationships as ER diagrams.

 

Provides you with a set of simple SQL statements.

 

Simple tools for and Updatable views


Prev Return to chapter overview Next