SQL Code Completion and IntelliSense
Published 29 October 2019
SQL Prompt offers as-you-type IntelliSense and code completion suggestions, as well as providing other information, and helping you navigate around your code. As you accept and insert the suggested code, SQL Prompt will, if required, also qualify an object to its owner, assign aliases to tables and views, and qualify columns with the correct alias.
Working with SQL Prompt is like using an interactive SQL version of a decision tree, or railroad diagram. It is the easiest and fastest way to navigate through a complex SQL command and, with it, developers will quickly gain a syntactical understanding of the SQL, while producing working code.
Documentation for SQL Code Completion and IntelliSense
- Using and Configuring Code Completion Suggestions (Quick Ref)
- Inserting suggestions into your code
- Inserting columns with the column picker
- Working with aliases
- Using the object definition box and object tooltips
- Using keyboard shortcuts
If you're new to using SQL Prompt, try following the worked examples.
Additional Resources for SQL Prompt Code Completion
In addition to this documentation, the Redgate Hub offers the following resources to help you find your way around SQL Prompt Code Completion and IntelliSense, learn how to use it, and adopt best practices :
- Redgate University online video classes:
- Product learning technical 'how-to' articles: