功能特色:
自动:建树/削减/呵护数据库备份/恢单数据库语法高亮效率规画代码天生SQL典型规画多个查问标签SQL查问批处置导出为CSV / XML的/ TXT等打印查问服从...等等。
情景:
该软件需要在Net 环镜下能耐运行,请安装 .NET Framework V2.0 可再刊行组件包: http://www.cr173.com/soft/2572.html
快捷键:
(sql 编纂器sql editor) 实施execute: f5, ctrl + e, alt + x
(sql 编纂器sql editor) 实施之后陈说式execute current statement: ctrl + enter
(sql 编纂器sql editor) 新增查问new query: ctrl + n
(sql 编纂器sql editor) 封锁查问close query: ctrl + f4
(sql 编纂器sql editor) 保存save: ctrl + s
(sql 编纂器sql editor) 剪下cut: ctrl + x
(sql 编纂器sql editor) 复制copy: ctrl + c
(sql 编纂器sql editor) 贴上paste: ctrl + v
(sql 编纂器sql editor) 全选select all: ctrl + a
(sql 编纂器sql editor) 復原undo: ctrl + z
(sql 编纂器sql editor) 重做redo: ctrl + y
(sql 编纂器sql editor) 搜查find: ctrl + f
(sql 编纂器sql editor) 取代replace: ctrl + h
(sql 编纂器sql editor) 跳至指定行goto: ctrl + g
(sql 编纂器sql editor) 查问產生器query builder: ctrl + q
(sql 编纂器sql editor) sql格式化sql formatting: ctrl + m
(sql 编纂器sql editor) 主解co妹妹ent: ctrl + shift + c
(sql 编纂器sql editor) 作废主解unco妹妹ent: ctrl + shift + u
(sql 编纂器sql editor) 以方格展现服从results to grid: ctrl + 1
(sql 编纂器sql editor) 以翰墨展现服从results to text: ctrl + 2
(sql 编纂器sql editor) 将服从存档results to file: ctrl + 3
(sql 编纂器sql editor) 开啟行下方line open below*: ctrl + shift + enter
(sql 编纂器sql editor) 开啟行上方line open above*: ctrl + +
(sql 编纂器sql editor) 页籤封锁close tab*: middle-click
(sql 编纂器sql editor) 下一个窗格next pane: f6
(sql 编纂器sql editor) 上一个窗格previous pane: shift + f6
(sql 编纂器sql editor) 服从窗格results pane: ctrl + r
(自动实现与智能感知autocomplete and intellisense(*)) 插入insert*: space, enter, tab, =
(自动实现与智能感知autocomplete and intellisense(*)) 列出成员list members*: ctrl + j, shift
(自动实现与智能感知autocomplete and intellisense(*)) 列出程式码片断list code snippets: ctrl + k
(自动实现与智能感知autocomplete and intellisense(*)) 方式切换toggle completion mode: ctrl + alt + space
(自动实现与智能感知autocomplete and intellisense(*)) 智能感知开关toggle intellisense on or off: ctrl + i
(质料表编纂table designer) 削减栏位insert column: ctrl + n
(质料表编纂table designer) 删除了栏位delete column: delete
(质料列编纂data editor) 保存save: ctrl + s
(质料列编纂data editor) 刷新refresh: f5
(质料列编纂data editor) 剪下copy: ctrl + x
(质料列编纂data editor) 复制copy: ctrl + c
(质料列编纂data editor) 贴上copy: ctrl + v
(质料列编纂data editor) 删除了列delete row: delete
(质料列编纂data editor) 配置质料栏位為空值set cell as null: ctrl + 0
(质料列编纂data editor) 挪移至新列move to new row*: ctrl + n
(质料列编纂data editor) cell 编纂器cell editor(*): ctrl + e
(质料列编纂data editor) form 编纂器form editor(*): alt + v
(质料列编纂data editor) 批次汇入import: ctrl + i
(质料列编纂data editor) 搜查find: ctrl + f
(质料列编纂data editor) 移至质料列goto: ctrl + g
(质料列刘览data browser) 汇出export: ctrl + s
(质料列刘览data browser) 复制copy: ctrl + c
(质料列刘览data browser) 全选select all: ctrl + a
(质料列刘览data browser) 列印print: ctrl + p
(质料列刘览data browser) cell 刘览器cell viewer: ctrl + v
(质料列刘览data browser) form 刘览器form viewer: alt + v
(质料列刘览data browser) 搜查find: ctrl + f
(质料列刘览data browser) 移至质料列goto: ctrl + g
(物件刘览object navigator) 物件快捷筛选quick filter: ctrl + 2
(物件刘览object navigator) 复制copy*: ctrl + c
(物件刘览object navigator) 睁开/收合expand/collapse: ctrl + right
(物件刘览object navigator) 刷新refresh: f5
(程式码规画code manager) 复制copy*: ctrl + c
(程式码规画code manager) 刷新refresh: f5
(程式码规画code manager) 搜查输入searchbox: enter, f5
(所有标籤all tabs) 下一个页籤next tab*: ctrl + tab
(所有标籤all tabs) 上一个页籤previous tab*: ctrl + shift + tab
反对于:
MS Access 97-2003(*. mdb;*.*)MS Access 2007(*. accdb)MS Excel97-2003(*. xls)微软Excel 2007(*. xlsx)dBASE IV(*.dbf)火鸟(*. gdb,*.fdb)MySQLSQL ServerSQL AzureSQL Server CE(*.sdf)SQLite(*.db, *. db3,*. sqlite)PostgreSQL甲骨文数据源(OLE DB)ODBC文件DSN(数据源称谓)所有功能重大以及自力(不装置)
更新日志:
Ver 8.2.4846 (2013/04/08) 晃动版 - 质料表编纂(Table Editor): Add: 削减运用者界说质料规范(User-Defined Data Types)(Domains)的反对于(含物件瀏览与剧本天生)(4846) 当初已经全部反对于所有质料库(PostgreSQL/SybaseASE/IBM DB2/Informix/Firebird/SQLAzure/SQLServer) Add: (PostgreSQL) 削减质料规范 Serial (AutoIncrement) 的反对于(含物件瀏览与剧本天生)(4846) Fix: (Oracle) 改善与更正 Number 质料规范处置(当未指定精确度或者非预设数值规范时(如Integer))(含物件瀏览与剧本天生)(4846) Fix: 质料表剧本编纂方式(Script Mode): 1.当保存失败后复原质料表未定义前称谓, 2.点击保存后未重刷更新的下场(4846) - 质料列编纂与瀏览(Data Editor and Browser): Add: 新增跳至指定行与移至质料列(Goto Line and Goto Row)等功能与快捷按键Ctrl G(4846) Fix: 瀏览方式下[原]移至质料列(Go To Row)功能消逝的下场(4846) Add: (Informix) 削减 Serial8 and BigSerial 等质料规范, 自动递增栏位数值(同 Serial)(4846) - 剧本天生(Data Definition Language): Add: 物件瀏览 SEQUENCES 开啟右键选单, 削减 SCRIPT AS (CREATE) 剧本天生(4846) 反对于所有质料库(Firebird/Oracle/PostgreSQL/SQLServer/IBM DB2/Informix) Upd: (Oracle) 更新 Index 剧本天生内容输入(翦灭 segment attributes)(4846) - SQL 效力合成器(SQL Profiler*): Add: SQL 命令展现视窗削减 SQL 格式化功能(当未装置外部格式化工具时, 自动採用内建重大格式化处置)(4846) - 自动实现与感知(Auto Complete and IntelliSense*): Fix: 更正未选定列表成员时点击 Period Key[.] 键, 游标仍自动右移的下场(4846) - 主程式更新(Main): Upd: (IBM DB2) 更新 FUNCTIONS 物件瀏览(仅展现 User-Defined Functions 物件)(4846) Upd: 防止用户透过快捷键(Alt F4)欺压封锁期待处置中的展现页, 而导致后续无奈个别运作的下场(4846) Upd: (OData) 大幅提升切换至 (Tree) 树状质料瀏览时展现速率(4846) Add: (SQLServer/SQLAzure/SybaseASE) 削减[妄想形貌表当初质料表以前]的潜在配置(table (schema)->schrma.table )(4846) Upd: 其余搜罗多处小幅更正与优化更新...等积攒处置(4846) Misc: 相容於 PostgreSQL 9.2.4 (2013/04/04) / 9.1.9 (2013/04/04) / 9.0.13 (2013/04/04)