| 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 |
|
|
| ms.assetid | 9ebd08b6-fa93-4581-bb6c-96b51d2c895c | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg |
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.
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.
Design Queries and Views How-to Topics (Visual Database Tools)