JSqlTool

View and edit database tables content with this app.
Download

JSqlTool Ranking & Summary

Advertisement

  • Rating:
  • Price:
  • Free
  • Publisher Name:
  • By Mauro Carniel
  • Operating Systems:
  • Windows 2000, Windows Vista, Windows, Windows 7, Windows XP
  • Additional Requirements:
  • None
  • File Size:
  • 3.3 MB
  • Total Downloads:
  • 27

JSqlTool Tags


JSqlTool Description

JSqlTool is a small, easy to use, Swing based software used to view / edit database tables content and to execute SQL scripts, by connecting to a database using JDBC/ODBC. It'a a multilanguage application, tested on Oracle, SQLServer, MySQL, DB2 and many other databases. This application will help you: · connect to a database, using a JDBC or ODBC Driver · view tables, views and synonyms list · for each table/view/synonym see entity details, like: structure, data, indexes, constraints, SQL script and triggers · table data can be visually ordered/filtered; you can add/edit/delete records directly on the table data grid · table data can be exported as insert SQL statements, as text or in an Excel File Format (XLS) · edit SQL statements in a SQL shell (by coloring SQL text according to syntax), by means of it you can execute queries or other statements and see query results; queries may contain parameters · previous SQL statements are recorded to allow re-call and re-execution · view a database schema E/R diagram, store and recall schemas, print and export them · replicate a set of tables to another schema, by creating tables and populating them. Replication task can be replicated to update data · many other features are available, according to the database type: edit/drop contraints, execution query explain plan, trace sessions.


JSqlTool Related Software