Today I'm going to introduce you to SQL Assistant, a free tool for adding intelliisense to T-SQL and PL/SQL.
To implement SQL intelliisense, simply put, the SQL code is automatically filled. With this, it is very convenient to write code.
The tool is built in to DB tools for Oracle, MS Enterprise Manager, ms SQL Server Management studio, ms SQL Server Management studio Express, MS query analyzer, vs 2003, VS 2005, supports notepad and SQL plus W. Since this tool implements the SQL intellisense function through plug-ins, it theoretically supports n multi-editor. I will introduce you to how to configure SQL assistant to add the SQL intellisense function to the tablet.
SQL Assistant Official Website: http://www.softtreetech.com/isql.htm
The following is a demo of some SQL asistant functions:
SQL query analyzer example
SQL * Plus example
Now I will introduce how to configure SQL assistant to add the SQL intellisense function to the WordPad:
First, open the WordPad program and place the cursor in the text editing area.
Then, open SQL assistant and press Ctrl + F5. A dialog box is displayed. Click OK after setting SQL compliance, SQL renference, and code snippets.
After completing the preceding steps, you have added the SQL intellisense function to the WordPad program. If you want to modify the settings later (for example, if you want the WordPad program to support PL/SQL intelliisense), press Ctrl + F5. the dialog box will pop up again. Modify the settings and save the settings.
The text above only serves as an example. You can add the SQL intellisense function to your favorite text editor.
P.s: I tested it briefly. Programs Written in Java do not support SQL assistant, and emeditor does not. Other editors are not tested. In general, the SQL assistant function is good and supports most commonly used editors, but the stability is not very good. Sometimes the editor is suspended or suddenly closed during use. However, SQL assistant is currently only a beta version, and we believe that the stability of later versions will be improved.