DtSQL 2.8.1 - Universal database query and editor tool. (Free)

DtSQL is a universal database query and editor tool for developers and database administrators to Query, Edit, Browse, and Manage Databases. It can access most databases and can be used on all major operating systems. Supported Databases: Cache DB2 Derby Firebird FrontBase H2 HSQLDB Informix Ingres JDatastore MaxDB Mckoi Mimer MySQL Oracle PointBase PostgresSQL Solid SQLite SQL Server SQL Anywhere Sybase (ASE) Features: Database Browser: browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on. Database Tools: create, alter, view and drop tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on Data Management: edit table data including binary/BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete table data. Find and replace data, preview generated SQL. Redo or undo last table data change before update is committed. SQL Tools edit, format and execute SQL scripts. SQL Builder: help tools to build select, insert, update, delete SQL scripts. Import Data: import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern. Export Data: export data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern. Version 2.8.1: Add ( Ctrl + Enter ) to execute current SQL Add new function to change the key to execute SQL and trigger SQL Editor Auto Coplete. (Prefererences->Key) Add new buttons to convert SQL Editor characters to lower case and reverse Add 'Goto Line' button in SQL Editor Add line number to DDL text area (trigger, procedure, function and so on) Add loading progress while copying selected table data Cache and save each table filter and sort sql Add 'Reset' button to 'Filter & Sort' panel Support export system information Fixed bug in which 'Replace' does not show the changed characters in SQL Editor Fixed bug in which view script is not formatted and showed in one line Fixed bug in which MySQL does not show view in information schema Fixed bug in which Db2 does not show procedure DDL OS X 10.5 or later Java 1.6 or later More information Download Now

Put the internet to work for you. via Personal Recipe 3539690