Database Tools Features

DtSQL is an universal database tools which can create, alter, browse and search database objects, execute SQL scripts and edit tables.

Supported Databases

DtSQL supports most databases : Cache, DB2, Derby / JavaDB, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MariaDB, MaxDB, Mckoi, Mimer, MySQL, MongoDb, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQlite, SQL Server, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise (ASE) .

Database Browser

• Tools to browse table information and contents
  • Column information
  • Table creating DDL
  • Primary keys
  • Foreign keys
  • Table constraints
  • Record count
• Tools to browse database view information and contents
• Tools to browse database index information and DDL
• Tools to browse database trigger information and DDL
• Tools to browse database constraint information
  • Primary Keys
  • Foreign Keys
  • Check Constraints
  • Unique Constraints
• Tools to browse database function information and DDL
• Tools to browse database stored procedure information and DDL
• Tools to browse database sequence information

Database Tools

• Tools to create, alter, rename, truncate and Drop Tables
  • Add, rename and drop Columns
  • Change column data types
• Tools to create, alter, rename and drop Views
• Tools to create, alter, rename and drop Indexes
• Tools to create, alter, rename and drop Triggers
• Tools to create and drop Constraints
  • Primary Key
  • Foreign Key
  • Check Constraint
  • Unique Constraint
• Tools to create, alter, rename and drop Procedures
• Tools to create, alter, rename and drop Functions
• Tools to create, rename and drop Sequences

Database Management Tools

• Edit database table data including binary/BLOB and CLOB data types.
• Format database table data according to applied integer, timestamp, binary/BLOB, CLOB and boolean pattern
• Filter, sort and search query result.
• Insert, duplicate, update, and delete table data.
• Find and replace data, preview generated SQL.
• Restore deleted database table rows before update is commit
• Redo or undo database table data changes before commit

SQL Tools

• Format SQL scripts according to customization options
• Support SQL variables bound
• Support Execute SQL
  • In a single statement
  • In multiple SQL statements
  • Statement at cursor position
  • Selected text as a single SQL statement
• Sort and filter database query results
• Display SQL query history
• Print editor content and query database table results

SQL Builder

• Help tools to to build Select, Insert, Update and Delete scripts of most databases

Import Data

• Import database data from various formats
  • CSV files
  • Excel files
  • SQL insert statements
  • Fixed-width files
• Parse import database data according to integer, date, time, timestamp, and boolean pattern

Export Data

• Export data (single table/multiple tables/query result) in various formats
  • CSV files
  • Excel files
  • XML files
  • HTML files
  • SQL insert statements
  • Fixed-width files
• Format export data according to applied integer, date, time, timestamp, and boolean pattern

Built-In Database

• Built-In Database (HSQLDB) is included in the application without any configuration