• Article

DataType Constructor (SqlDataType, Int32)

Initializes a new instance of the DataType class based on a specified SQL Server data type with specified precision or maximum length.

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

Syntax

'Declaration
Public Sub New ( _
    sqlDataType As SqlDataType, _
    precisionOrMaxLengthOrScale As Integer _
)
'Usage
Dim sqlDataType As SqlDataType
Dim precisionOrMaxLengthOrScale As Integer

Dim instance As New DataType(sqlDataType, _
    precisionOrMaxLengthOrScale)

public DataType(
    SqlDataType sqlDataType,
    int precisionOrMaxLengthOrScale
)

public:
DataType(
    SqlDataType sqlDataType, 
    int precisionOrMaxLengthOrScale
)

new : 
        sqlDataType:SqlDataType * 
        precisionOrMaxLengthOrScale:int -> DataType

public function DataType(
    sqlDataType : SqlDataType, 
    precisionOrMaxLengthOrScale : int
)

Parameters

  • precisionOrMaxLengthOrScale
    Type: System.Int32
    An Int32 value that specifies the precision for numeric SQL Server data types and maximum length for text based SQL Server data types.

Examples

Visual Basic

Dim dt As DataType
dt = New DataType(SqlDataType.

PowerShell

$dt = new-object Microsoft.SqlServer.Management.Smo.DataType([Microsoft.SqlServer.Management.Smo.SqlDataType]::