UserDefinedDataType.NumericScale Property
Gets or sets the maximum number of digits to the right of the decimal point in a numeric value used in the definition of the user-defined data type.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.ReadOnlyAfterCreation | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase | SfcPropertyFlags.Design)] public int NumericScale { get; set; }
Property Value
Type: System.Int32A Byte value that specifies the numerical scale of the user-defined data type.
Numerical scale specifies the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a numerical scale of 2.
UserDefinedDataType Class
Microsoft.SqlServer.Management.Smo Namespace
Data Types (Database Engine)
CREATE TYPE (Transact-SQL)
Show: