欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
SQLeonardo
来自开放百科 - 灰狐
（版本间的差异）
| 第11行： | 第11行： | ||
==功能特性== | ==功能特性== | ||
| − | |||
General | General | ||
| − | |||
* freeware software | * freeware software | ||
* platform-independent | * platform-independent | ||
| 第20行： | 第18行： | ||
Metadata Explorer | Metadata Explorer | ||
| − | |||
* browse database structure as tables, views, keys, indices etc. | * browse database structure as tables, views, keys, indices etc. | ||
* search tables and columns | * search tables and columns | ||
Command Editor | Command Editor | ||
| − | |||
* create, edit, and execute SQL scripts | * create, edit, and execute SQL scripts | ||
* generate insert, update and delete statements through a wizard | * generate insert, update and delete statements through a wizard | ||
Query Builder | Query Builder | ||
| − | |||
* create SQL queries without directly writing SQL | * create SQL queries without directly writing SQL | ||
* joins between tables are automatically created | * joins between tables are automatically created | ||
| 第36行： | 第31行： | ||
Data Grid | Data Grid | ||
| − | |||
* edit tables directly via the data grid | * edit tables directly via the data grid | ||
* generate SQL statements for any change | * generate SQL statements for any change | ||
| 第42行： | 第36行： | ||
* export data as INSERT statements, html, text (user can define separator) | * export data as INSERT statements, html, text (user can define separator) | ||
* import data | * import data | ||
| − | |||
==相关链接== | ==相关链接== | ||
2010年9月26日 (日) 10:13的最后版本
目录 |
[编辑] 简介
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
[编辑] 相关链接
[编辑] 屏幕截图
分享您的观点
