Returned Column Properties
These are the properties of columns returned by table-valued functions. To access them, open the Function node of your data source connection in Server Explorer, open the Table-Valued Function node, open the Returned Column node, and click the column for which you want information. If you do not see the Returned Column node, right-click the connection node of your data source, point to Change View, and click By Object Type.
Note
The properties in this topic are ordered by category rather than alphabet.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
Identity Category
Expands to show the Name property.Name
Shows the name of the column.Misc Category
Expands to show the remaining properties.Data Type
Shows the data type of the selected column.Is Identity
Shows whether the selected column is the identity column for the table.Length
Shows the number of characters allowed for character-based data types.Nullable
Shows whether or not the column allows null values.Precision
Shows the maximum number of digits allowed for numeric data types. This property shows 0 for nonnumeric data types.Scale
Shows the maximum number of digits that can appear to the right of the decimal point for numeric data types. This value must be less than or equal to the precision. This property shows 0 for nonnumeric data types.