MS SQL Field Box 2.5
|
price: Free |
MS SQL Field Box it is a small tool which allow you view MS SQL Server database structure and paste table or field names in your favorite editor with mouse left double click or keyboard hotkeys. It's a another way of using "IntelliSense" technology :)
MS SQL Field Box helps you to type your T-SQL statements if you are still using the Query Analyzer or MS SQL Server Management Studio Express. You can reach more productivity using both technologies "IntelliSense" and "Field Box".
Features
You can view:
• list of the databases
• tables and their fields
• views and their fields
You can paste in your editor:
• table name
• table field name
• view name
• view field name
• Ctrl+MouseLeft2 or Ctrl+Enter adding comma at end of a pasted name
Requirements
The program uses ADO, therefore you need in installed MDAC, usually it can be installed with MS SQL Client tools.
Quick start
1. Run a MS SQL Field Box
2. Run a Query Analyzer (or any editor)
3. Double click of left mouse button on table or field name in MS SQL Field Box window
4. And... Selected table or field will be pasted into Query Analyzer.
Hotkeys (recommended)
• Alt+R - reconnect to server
• F9 - program preferences
• Alt+A - sets or removes Alias for Table
• Ctrl+U - select a database
• Alt+X - exit
• Ctrl+Alt+R restores list box format
• MouseLeftDoubleClick on caption - roll the window up/down
• MouseLeft2 (or Enter) on Tables List - paste the highlited TableName in active editor. If Alias for table exists then it will be added.
• Ctrl+MouseLeft2 (or Ctrl+Enter) on Tables List - paste the highlited TableName in active editor with comma.
• MouseLeft2 (or Enter) on Fields List - paste the highlited FieldName in active editor. If Alias for table exists then it will be added.
• Ctrl+MouseLeft2 (or Ctrl+Enter) on Fields List - paste the highlited FieldName in active editor with comma.
You can set the global hotkeys for bringing the window front/back and rolling up/down. See the program preferences.
Also you can add the "MS SQL Field Box" in the "Tools"-menu if you are use Query Analyzer or MS Studio Express.
Related products:
CWTools 1.1| History | ||
| 2.5 | 2009-10-14 | Find feature |
| 2.4 | 2009-03-10 | Schema support for 2005, 2008 |
| 2.3 | 2008-07-10 | Templates |
| 2.2 | 2006-05-02 | View relations |
| 2.1 | 2006-04-12 | View indexes |
| 2.0 | 2006-01-10 | Change product name & compile with C7, new look, now you can choose database from drop list |
| 1.1 | 2005-06-16 | Some changes for compatibility with Russian code page |
| 1.0 | 2005-06-07 | Original (first) release |
