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

Subscribe to our news:
Partners

Features of ASA Maestro:

Queries and Scripts

If you intend to use ASA Maestro  for working with SQL queries and scripts, the most powerful (and at the same time easy!) tools are at your fingertips.

SQL Editor is the basic ASA Maestro tool for creating and executing queries that supposed to return data.

The editor allows you to create and edit SQL text for the query, prepare and execute queries and view the results of execution. It also includes such useful features as syntax highlighting, hyperlinks, and code auto completion.

It is also possible to execute several queries at a time: just enter their texts separated by semicolon in the SQL Editor and press the Execute button. Execution of the selected text only is also available.

Visual Query Builder is meant for building queries visually.

You can create and edit queries even without knowledge of SQL: preparing and executing queries, viewing the results of the execution become simple operations when performed with the help of Visual Query Builder.

Using SQL Script Editor you can view, edit and execute SQL scripts.

To open the editor, just select the Tools | SQL Script Editor main menu item. Within the editor you are able to perform all the necessary operations with SQL scripts.

Back Next