intellisense-sql-server-management-studio.md

title	IntelliSense (SQL Server Management Studio) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
ms.assetid	7d6b0f60-c6ac-4f71-a9d0-fc3c2ffa7e91
caps.latest.revision	7
author	BYHAM
ms.author	rickbyh
manager	jhubbard

IntelliSense (SQL Server Management Studio)

The editors in [!INCLUDEssManStudioFull] support [!INCLUDEmsCoName] 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

[!INCLUDEmsCoName] 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)