seeMore SQL Query allows multiple connections to your enterprise data. Within a single connection you can have multiple queries executing at the same time.

Results can be saved as TEXT, CSV or XML data. Alternatively they can be saved as SQL insert statements.

Database objects can be dragged and dropped into the SQL editor to build queries quickly. When selecting more than one table to drag and drop, the SQL editor will automatically generate the FROM and WHERE clauses if the tables are found to be related.

The SQL editor provides for database object lookup and auto-complete. It also allows SQL Keywords to be typed in and auto-completed when the SQL Keyword accelerator key is pressed.

• Comes with a JDBC Data source and driver manager allowing your database connections to be easily created and maintained;
• Allows connections to both ODBC and JDBC data sources where supported;
• Allows multiple active database connections;
• Each database connection can have multiple active queries;
• Easy to navigate database objects window providing access to:
  • Schemas
  • Tables and their objects:
    • Columns;
    • Indexes;
    • Relationships;
    • Dependencies;
    • Triggers and their DDL statements ;
  • Views and their DDL statements
  • Stored Procedures and their DDL statements
  • Supported Data types.
• Properties window showing the property for any selected database object;
• Context sensitive menus allowing to quickly create SQL statements;
• Auto-complete support for both database objects and SQL keywords;
• Allows you to easily create and maintain Tables, Views, Triggers and Stored Procedures;
• The results window allows the data returned from your executed SQL to be displayed:
  • as multiple rows or as a single row for convent viewing of data;
  • to be searched within the result set;
  • to be fully or partially saved as:
    • a TEXT file;
    • a CSV file;
    • a XML file;
    • or a SQL script containing insert statements ;
• SQL editor can be configured to suit your own personnel look and feel;
• The History window shows all SQL statements executed during the connection as well as their times of execution.
• The ability to save SQL statements as scripts allowing them to be executed later;

The seeMore Query explorer can access any JDBC or ODBC based data source.
The product has been verified to work with the following databases:

• seeMore Standard and Virtual Database Servers
• Microsoft SQL Server 2000 and 2005
• Microsoft Access 2003
• IBM DB2 V8 and V9
• Oracle 9i and 10g
• Ingres V9
• MySQL V5
• ANTs Data Server V3
• Enterprise DB v9