JSqlTool Swing based application used to view/edit database tables content and to execute sql scripts
Download

JSqlTool Ranking & Summary

JSqlTool Tags

view edit execute database editor database viewer execute sql script

JSqlTool Description

Swing based application used to view/edit database tables content and to execute sql scripts JSqlTool is a Swing based application used to view/edit database tables content and to execute sql scripts, by connecting to a database using JDBC/ODBC. JSqlTool is a a multilanguage application, tested on SQLServer, MySQL, Oracle, DB2 and many other databases.NOTE: JSqlTool is licensed and distributed under the terms of the GNU Lesser General Public License (LGPL). Here are some key features of "JSqlTool": · 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