This text will introduce SQL Intellisense input function, supplied by database design tool BDB.

1. SQL auto-complete function

SQL auto-complete function, that is, when doing query analysis, you are no need to input the table name and field name or SQL
keywords, the system will automatically doing the present SQL grammar analyzing, list the most suitable item of the user's present input. Press "ENTER" or choose the item, and you
can complete the input automatically.

Thus it is very convenient to carry out Query Analyzing grammar input. At the same time. BDB offers further support for field
display, for example, it will automatically list field declaration in the field list. Thus even if you can not remember the field name,
you can finish the input quickly.

2. Doing Intellisense Query Analyzsis through BDB

Basic operation

the process is as following:
1) Run BDB and set the database connection.
2) Switch to the page of "Query".
3) Now there are two ways for quick input
A. Input the character directly. For example if you want to input the grammar "SELECT...", you can first input "s",
the system will search for and list all the matching items beginning with "s" automatically. Then you can choose from the
popping list directly.
B. Press the shortcut key CTRL+J to pop up the choice list, and retrieve.
Note: the shortcut key CTRL+J can be altered in the "options"
4) Retrieve the list item.
If you want to retrieve the list item, you can use the mouse to click directly or press "ENTER" or "SPACE". If you want to
cancel, you can press "ESC" or
the right key or the shortcut key CTRL+J again.
5) Execute the grammar
Click the button "execute" or the shortcut key CTRL+ENTER(ALT+ENTER)

Above is the basic function BDB offers, if you further input the grammar, the system will begin to do grammar analysis.
For example, after you input "SELECT * FROM" and press the shortcut key "CTRL+J", the system will list all tables at the top of the list:

After you input the table name, if you need to choose the input field, the system will automatically list all fields, field discriptions
and data types on the topmost for quick input.

 

Propulsion phase

1) Efficiency optimization
In order to optimize the efficiency, when it loads the list, BDB will always give priority to load the table structure from the source
files; and if the file does not exist, it will take the table structure from the entity database. So in order to achieve better execution
efficiency, you can first save the table structure to the file.
( choose from the tollbar "file"- "save" or "save all")

2) The way to set the field discriptions
Under the defaut situation, the field discription will be set as the field name. You can set the display name of the field on the page of the table structure, then press CTRL+S or directly click "save". If you setted the attribute, the system will show the field discription when listing the field list.

3) Shorten the input function
BDB offers the shortening input function simultaneously. For example, if you want to input the grammar "SELECT* FROM",
you only need to configure the shortening item of the grammar and choose the shortening item in the list. For example, you can set "S*F" as the shortening item of the grammar. If you want to configure more shortening items, you can open the file "DBS\Snippets.txt" under the system setting-up catalogue to add language and the corresponding message of the shortening items

4) configure the key word list
It will list the keyword list in the auto-complete list popped-up by the system. You can also self-define these lists through
the system configuration. The concrete operation is to choose and click "tools"- "options" in the toolbar, choose the page
"edit"-"keywords" in the opened page, then click "save".

5) "DESC" grammar
BDB offers "DESC" quick query grammar of the full function. Through this function, if only you choose or input simple
"DESC" grammar, you will obtain the message, such as tables, views, procedures in the present database. Including:
->desc [tables]
Take all tables information of the user.
->desc [table]
Take the present table information of the user.
->desc TableName
Take table description
->desc [constraints]
Get all the constraint description of the present table.
->desc [AllConstraints]
Get all the constraint description of the database.
->desc [indexes]
Get all the index description of the present table.
->desc [AllIndexes]
Get all the index description of the database.
->desc [foreignkeys]
Get all the foreign key description of the present table.
->desc [AllForeignkeys]
Get all the foreign key description of the database.
->desc [AllTriggers]
Get all the trigger description of the database.
->desc [triggers]
Get all the trigger description of the present table.
->desc [data]
Get the data of the present table.
->desc [Views]
Get all the view description of the database.
->desc [Functions]
Get all the fuction description of the database.
->desc [Procedures]
Get all the procedure description of the database.

6) derive out query analysis data
After carrying out query analysis, you can derive out the query result to the Excel file. The exact operation is
"file" - "export to file", and confirm the deriving in the poping dialog box. You can also click the right key menu in the grid title bar and choose the
item "export to file".



3. the database platform supported in BDB

Besides SQLServer(including MSDE), BDB also supports Oracle, MySQL, Access, SQLAnywhere and Sybase.


Note: BDB is the software of the database design, deployment and migration issued by bainsoft. It's latest edition can be downloaded from www.bainsoft.com