UserDefinedDataType.NumericPrecision Property

Gets or sets the maximum number of digits in a numeric value used in the definition of the user-defined data type.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property NumericPrecision As Integer
public int NumericPrecision { get; set; }
public:
property int NumericPrecision {
    int get ();
    void set (int value);
}
/** @property */
public int get_NumericPrecision ()

/** @property */
public void set_NumericPrecision (int value)
public function get NumericPrecision () : int

public function set NumericPrecision (value : int)

Property Value

A Byte value that specifies the numerical precision of the user-defined data type.

Remarks

Numerical precision specifies the number of digits in a number. For example, the number 123.45 has a numerical precision of 5.

The numerical precision cannot be set to a value greater than the MaxLength property value.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Construct a DataType Object by Using the Default Constructor in Visual Basic .NET

How to: Construct a DataType Object with the Specification in the Constructor in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

UserDefinedDataType Class
UserDefinedDataType Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Data Types (Database Engine)
CREATE TYPE (Transact-SQL)