From: http://www.cnblogs.com/huacn/archive/2007/04/28/ SQL _Prompt_3.html
A good SQL query analyzer auxiliary tool found yesterday. SQL prompt 3 is not cracked, and it seems to be a 15-day trial.
Its main function is to automatically detect the SQL query analyzer. When we input content in the query analyzer, it will automatically find the corresponding table name, field, stored procedure or view, the appearance of a candidate column table is really convenient. The function of Automatic completion is always lacking in SQL. It seems that sql2005 still does not have the function of Automatic completion. But I really want to have this thing, because even if the database is designed by myself, but there are too many tables that will always be forgotten, so the previous practice is to open the design window, write query while copying fields.
I found a querycommander some time ago, which has an automatic completion function. However, after a while, I found that it was too easy to use and sometimes it made me angry, another thing is that it seems that the input cursor is not correct with the input point. This makes me feel miserable, and then I decided not to use it any more. However, if I have time, I can modify it based on it, after all, it is open-source.
Well, let's leave it alone. Let's take a look at some of my work.
SQL prompt 3 Figure 1-automatically list tables for easy selection
SQL prompt 3 Figure 2-Where can I select the following icons to view only the "View" objects?
SQL prompt 3 Figure 3-the Query Form can come from the stored procedure.
SQL prompt 3 Figure 4-system functions can also be listed
SQL prompt 3 Figure 5-it will also be automatically filtered with the input content
SQL prompt 3 Figure 6-this is what I think is the best function to automatically list fields that can be associated
SQL prompt 3 Figure 7-it's really convenient to call the Stored Procedure
: Http://downloads.red-gate.com/SQLPromptBundle.zip
SQL prompt 3 at http://www.red-gate.com
SQL ASSISTANT:
In addition, there is a software similar to free software, which supports more, and any DB2 MySQL can be used. However, I feel that SQL prompt is not easy to use, but the paid software is still well done.
The function is similar to the above one, but I always feel that it is not easy to use. The most annoying thing is its shortcut key. Even Ctrl + space is a hot key, which seriously affects my use. Fortunately, it can be modified, I turned off all the hot keys directly.
SQL ASSISTANT: http://www.softtreetech.com/download/sqlassist_setup2.exe
SQL assistant at http://www.softtreetech.com/isql.htm