Skip to content

Latest commit

 

History

History
28 lines (24 loc) · 2.14 KB

quick-info-intellisense.md

File metadata and controls

28 lines (24 loc) · 2.14 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic helpviewer_keywords monikerRange
Quick Info (IntelliSense)
Learn how to use the IntelliSense Quick Info option to display the complete declaration for any identifier in your code. In SQL Server Management Studio, the option is available in the Database Engine Editor and XML Query Editor.
markingmyname
maghan
03/14/2017
sql
ssms
conceptual
Quick Info option [IntelliSense]
declarations [IntelliSense]
IntelliSense [SQL Server], Quick Info
identifier declarations [IntelliSense]
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Quick Info (IntelliSense)

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW] The [!INCLUDEmsCoName] IntelliSense Quick Info option displays the complete declaration for any identifier in your code. When you move the mouse pointer over an identifier, its declaration is displayed in a yellow pop-up window. In [!INCLUDEssManStudioFull], Quick Info is available in the Database Engine and XML Query Editors.

Transact-SQL Quick Info

Quick Info displays two types of information in the [!INCLUDEssDE] Query Editor. When not in debug mode, Quick Info displays the expression declaration. When in debug mode, Quick Info instead displays the name of the expression and its current value.

In the [!INCLUDEssDE] Query Editor, Quick Info is available only for those parts of the [!INCLUDEtsql] syntax that IntelliSense supports. For example, if you move the mouse pointer over the identifier for an object that has a data type that IntelliSense does not support, the Quick Info pop-up window contains a message that states that the data type is not supported.

See Also

Transact-SQL Syntax Supported by IntelliSense