SQLeonardo

简介

SQLeonardo是一个强大易于使用的数据库管理工具。包括：

• Metadata Explorer 浏览数据库结构如表格，视图，主键,索引；
• Command Editor 创建，修改和执行SQL脚本。通过向导生成insert,update和delete语句；
• Query Builder 创建SQL查询不需要直接写SQL语句，自动创建表格之间的连接。支持union-query和sub-query；
• Data Grid 通过DataGrid直接修改表格，把数据导成INSERT语句等。

支持任何有JDBC驱动的数据库(Oracle,MS SQLServer,MySQL,DB2,Sybase, Firebird,HSQLDB,PostgreSQL,Apache Derby,Mckoi SQL)。

功能特性

General

• freeware software
• platform-independent
• supports multiple concurrent connections
• works with any JDBC compliant database (Oracle, MS SQLServer, MySQL, DB2,Sybase, Firebird, HSQLDB, PostgreSQL, Apache Derby, Mckoi SQL)

Metadata Explorer

• browse database structure as tables, views, keys, indices etc.
• search tables and columns

Command Editor

• create, edit, and execute SQL scripts
• generate insert, update and delete statements through a wizard

Query Builder

• create SQL queries without directly writing SQL
• joins between tables are automatically created
• support union-queries, also sub-queries

Data Grid

• edit tables directly via the data grid
• generate SQL statements for any change
• navigate database through his data (jumping from FK_record to PK_record or vice versa)
• export data as INSERT statements, html, text (user can define separator)
• import data

相关链接

• 官方网站 http://sqleonardo.altervista.org/

屏幕截图