The DBTools QueryIT is an excellent application for designing and creating queries. It was designed to allow users with no knowledge of database administration, create queries accessing data in their databases and export the results into other formats. The clean and improved User Interface can be easily mastered in a few minutes using the application.
QueryIT can access data in almost all database engines supported by DBManager Professional: Oracle, Microsoft SQL Server, Sybase, Microsoft Access, MySQL, PostgreSQL, Interbase, Firebird, SQLite, DBF Tables and ODBC Datasources.
It has two main features as follows:
- Query Editor: which is where all SQL and DDL commands can be manually typed and executed. With support for binary data (and image previewing) and memo (large text) fields, this Editor can show multiple results in tabs format.
- Table Datasheet: is a very useful designer to edit table's data. The designer is also capable of constructing comples queries, allowing the programmer to add one or more tables, create relationships between them, previewing sample data from selected tables. Also this feature allows to insert and export binary data from tables, when in editing mode.