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.