---
title: "Column List Dialog Box (Visual Database Tools) | Microsoft Docs"
ms.custom: ""
ms.date: "06/13/2017"
ms.prod: "sql-server-2014"
ms.reviewer: ""
ms.technology: ssms
ms.topic: conceptual
f1_keywords: 
  - "vdt.dlgbox.columnlist"
ms.assetid: 9ebd08b6-fa93-4581-bb6c-96b51d2c895c
author: stevestein
ms.author: sstein
manager: craigg
---
# Column List Dialog Box (Visual Database Tools)
  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)](visual-database-tools.md)