SQL prompt 3 excellent SQL query tools

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.