Share via


User-Defined Data Type Properties

These read-only properties appear in the Properties window when you select a user-defined data type in Server Explorer. These properties apply only to Microsoft SQL Server.

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 user-defined data type.

  • Misc Category
    Expands to show the remaining properties.

  • Default
    Displays the value that will be inserted into the column if the user does not make an entry. If no default value is defined and a column allows nulls, NULL will be inserted.

  • Length
    Shows the number of characters allowed for character-based data types.

  • Nullable
    Shows whether the data type allows null values.

  • Precision
    Shows the maximum number of digits allowed for numeric data types. This property shows 0 for nonnumeric data types.

  • Rule
    Displays the rule used to validate this data type.

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

See Also

Other Resources

Properties in Visual Database Tools