JSQLTool
本项目在 Java数据库客户端 中的评分:  7
JSQLTool is java swing SQL Tool which can be used to:
- 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
其他Java Java数据库客户端 开源项目资源:
|
