SQLCreator is an SQL query / developer tool designed to interact with many diverse relational database management systems.
Built using Java technology, SQLCreator offers a multiplatform solution for database interrogation and development. Additionally, the combination of Java with JDBC connectivity allows SQLCreator to interact with a vast array of diverse SQL databases.
Features The following is a list of features available within SQLCreator:
Multiple Database Support SQLCreator works with the majority of enterprise databases, including Oracle, Cache, SQLServer and DB2. Additionally SQLCreator can work with many popular open source and embedded databases, including MySQL, PostgreSQL, HSQLDB, Cloudscape and SAPDB.
Multiple Connections SQLCreator is capable of multiple concurrent connections to the same and different data sources.
Advanced SQL Editor Support In addition to the standard editing facilities (Undo, Redo, Cut, Copy, Paste, Find, Replace, etc.) the SQL editor supports syntax highlighting and code completion on tables, columns and keywords.
Database Navigator The Database Navigator provides a list of current database connections and a hierarchical tree view of each of the connections. The Database Navigator displays all catalogs, schemas, tables and columns for the current connection. Selecting the context (right click) menu on tables and columns displays options to automatically create common queries.
The Database Navigator fully supports drag and drop, tables and columns can be dragged onto Editors or the Relationship Map.
In addition to the hierarchical database view, the Database Navigator also has a Search tab which enables searching for specific tables using a variety of search criteria. It is possible to search for tables using table name or column name, the search can also be restricted by the catalog and schema that the table resides in.
Table Search In addition to the database tree view, it is possible to search for tables by any part of the table or column name. Searches may also be restricted by catalog or schema where relevant.
Database Connection Wizard A Wizard is available to ease the creation of new database connections. The Connection Wizard dynamically adjusts to the JDBC driver specified, considerably simplifying the process of creating new database connections.
Relationship Map The relationship map offers a graphical representation of the parent and child relationships of the selected table. In addition the relationship map can create SQL select statements based on the selected tables, creating theta join conditions between the related tables.
Statement Navigator After successful execution SQL statements are stored within the Statement Navigator. A tree view is automatically maintained with the SQL statement and details about it. Individual statements may also be assigned to groups, helping to keep logically related statements together.
Statement Search To ease retrieval of existing SQL statements, a search facility exists. This allows searching on given statements using keywords.
Mistyped Keyword Highlighting Highlighting of common keyword misspellings with automatic prompts to replace typos with the correct keyword.
Connection Alerts Any connection can be defined with an Alert. When enabled an Alert border is automatically displayed around the editor whenever the connection is active.
Other Features Include:
Parameter support
RTF clipboard support
User defined date formats
Viewing of supported image types (JPEG, GIF, PNG, BMP, ICO, TIFF) held within the database
Exporting SQL statement results (CSV & TXT)
Creation of select, insert, update and delete statements
Creation of queries based on a selected table or column
Statement formatting (Indent/Outdent, Change Case & Comments)
RSS stream reader, for up-to-the-minute news and technical information
Properties held against database objects, database connections and statements.
