IntelliSense (SQL Server Management Studio)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

The editors in SQL Server Management Studio support Microsoft IntelliSense options that reduce typing, provide quick access to syntax information, or make it easier to view the delimiters of complex expressions.

Benefits of IntelliSense

Microsoft IntelliSense provides an array of options that make language references easily accessible. When coding, you do not need to leave the editor to perform searches on language elements. You can keep your context, find the information you need, insert language elements directly into your code, and even have IntelliSense complete your typing for you.

IntelliSense Tasks

Task Description Topic
Describes how to configure IntelliSense options such as statement completion options or the size of Transact-SQL scripts for which you want IntelliSense turned off. Configure IntelliSense (SQL Server Management Studio)
Describes how to use Parameter Info to get information about the number, names, and sizes of parameters for a function or stored procedure. Parameter Info (IntelliSense)
Describes how to use Quick Info to get tooltips that describe an identifier (such as a table or view name). Quick Info (IntelliSense)
Describes how to have IntelliSense complete the rest of an identifier after you have typed in enough of the name to get a short list of objects whose names start with the same string. Complete Word (IntelliSense)
Describes how IntelliSense can identify both ends of a pair of delimiters, and how you can jump between the two ends of the pair. Automatic Matching of Syntax Pairs
Describes the conditions under which IntelliSense may not work. Troubleshooting IntelliSense (SQL Server Management Studio)

See Also

Query and Text Editors (SQL Server Management Studio)