column-list-dialog-box-visual-database-tools.md

title	Column List Dialog Box
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.dlgbox.columnlist
ms.assetid	9ebd08b6-fa93-4581-bb6c-96b51d2c895c
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Column List Dialog Box (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] When writing queries, it can be useful to see a list of columns available in your selected table-valued objects.

To access this dialog box, from the Query Designer menu, in the Diagram pane right-click the header of a table-valued object, and then click Properties. In the Properties window, click the Column List field. Then click the ellipses (...) to the right of the field.

This dialog box provides a list of the columns in the selected table-valued object and basic properties, such as data types and whether the columns allow null values.

Options

Name
Shows the name of the columns in the selected table-valued object.

Data Type
Shows the data types for each of the columns in the selected table-valued object.

Data Type Properties
Shows data type properties for each of the columns in the selected table-valued object. The possibilities are NULLABLE, IDENTITY, ROWGUID, and blank.

See Also

Design Queries and Views How-to Topics (Visual Database Tools)