Aqua Data
Studio is a database query and administration tool that allows
developers to easily create, edit, and execute SQL scripts,
as well as browse and modify database structures. Aqua Data
Studio provides an integrated database environment with a
single consistent inferface to all major relational databases.
This allows the database administrator or developer to tackle
multiple tasks simultaneously from one application.
Aqua Data Studio's sophisticated Query Analyzer allows
users to work on database scripts with specific RDBMS syntax
highlighting and auto-completion to develop and test SQL
scripts. Other features to speed up development include
SQL automation, auto-describe and a graphical table editor.
Its graphical browsing capabilities allow you to understand
the structure and dependencies of the database schema with
a single mouse click. The schema browser also allows you
to extract schema definitions by scripting SQL DDL and DML
(eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE)
syntax for database objects (including Tables, Views, Triggers,
Stored Procedures and Functions).
A powerful Table Data Editor allows you to modify your
results graphically and save them. By writing a single table
SELECT statement in the Query Analyzer and clicking on the
'Execute Edit' button, a separate window is opened with
the query results for you to edit and save.
Aqua Data Studio's Query Analyzer includes detailed client
statistical information and multi-grid results. Query result
options include text results, text history results, multi-grid
results, Oracle DBMS_OUTPUT and Client Statistics. It also
includes the ability to save your query results in many
formats including CSV (Character Separated Values), HTML
or XML.