Share via


Table-Valued Object (Column) Properties

These properties appear when you select a column in a table-valued object in the Diagram pane of Query and View Designer.

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 selected column.

  • Query DesignerCategory
    Expands to show properties for Allow Nulls, Collation, Datatype, Length, Precision, Scale, and Size.

  • Allow Nulls
    Shows whether or not the column's data type allows null values.

  • Collation
    Shows the collation setting for the selected column. The collation can be set in the Column Properties tab of Table Designer.

  • Data Type
    Shows the data type of the selected column.

  • Length
    Shows the number of characters or digits allowed by the selected column's data type. This property is only available for character-based data types.

    Note

    For the size in bytes, see the Size property below.

  • 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.

  • Size
    Shows the size in bytes allowed by the column's data type. For example, a nchar data type may have a length of 10 (the number of characters) but it would have a size of 20 to account for Unicode character sets.

See Also

Concepts

Table-Valued Objects

Other Resources

Properties in Visual Database Tools

Working with Columns