Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

IntelliSense (SQL Server Management Studio)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

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.

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)

Community Additions

ADD
Show:
© 2015 Microsoft