DataType Constructors

Definition

Overloads

DataType()

Creates a new DataType object.

DataType(SqlDataType, String, String)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. The type parameter specifies a SQL Server type string, i.e. "varchar(10)", an Xml schema collection, a user defined type, or a user defined type.

DataType(SqlDataType, String)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. The type parameter specifies a SQL Server type string, i.e. "varchar(10)", an Xml schema collection, a user defined type, or a user defined type.

DataType(SqlDataType, Int32)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. MaxLength specifies the maximum length of the type. In case of Decimal or Numeric, maxLength specifies the precision.

DataType(XmlSchemaCollection)

Allows a DataType object to be created based on a XmlSchemaCollection instance.

DataType(SqlDataType, Int32, Int32)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. Precision and scale define the numeric precision and scale of Decimal and Numeric types. The scale may be 0.

DataType(UserDefinedTableType)

Allows a DataType object to be created based on a UserDefinedTableType instance.

DataType(UserDefinedDataType)

Allows a DataType object to be created based on a UserDefinedDataType instance.

DataType(SqlDataType)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type.

DataType(UserDefinedType)

Allows a DataType object to be created based on a UserDefinedType instance.

DataType()

Creates a new DataType object.

public DataType ();
Public Sub New ()

Applies to

DataType(SqlDataType, String, String)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. The type parameter specifies a SQL Server type string, i.e. "varchar(10)", an Xml schema collection, a user defined type, or a user defined type.

public DataType (Microsoft.SqlServer.Management.Smo.SqlDataType sqlDataType, string type, string schema);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.SqlDataType * string * string -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (sqlDataType As SqlDataType, type As String, schema As String)

Parameters

sqlDataType
SqlDataType
type
String
schema
String

Applies to

DataType(SqlDataType, String)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. The type parameter specifies a SQL Server type string, i.e. "varchar(10)", an Xml schema collection, a user defined type, or a user defined type.

public DataType (Microsoft.SqlServer.Management.Smo.SqlDataType sqlDataType, string type);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.SqlDataType * string -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (sqlDataType As SqlDataType, type As String)

Parameters

sqlDataType
SqlDataType
type
String

Applies to

DataType(SqlDataType, Int32)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. MaxLength specifies the maximum length of the type. In case of Decimal or Numeric, maxLength specifies the precision.

public DataType (Microsoft.SqlServer.Management.Smo.SqlDataType sqlDataType, int precisionOrMaxLengthOrScale);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.SqlDataType * int -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (sqlDataType As SqlDataType, precisionOrMaxLengthOrScale As Integer)

Parameters

sqlDataType
SqlDataType
precisionOrMaxLengthOrScale
Int32

Applies to

DataType(XmlSchemaCollection)

Allows a DataType object to be created based on a XmlSchemaCollection instance.

public DataType (Microsoft.SqlServer.Management.Smo.XmlSchemaCollection xmlSchemaCollection);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.XmlSchemaCollection -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (xmlSchemaCollection As XmlSchemaCollection)

Parameters

xmlSchemaCollection
XmlSchemaCollection

Applies to

DataType(SqlDataType, Int32, Int32)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type. Precision and scale define the numeric precision and scale of Decimal and Numeric types. The scale may be 0.

public DataType (Microsoft.SqlServer.Management.Smo.SqlDataType sqlDataType, int precision, int scale);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.SqlDataType * int * int -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (sqlDataType As SqlDataType, precision As Integer, scale As Integer)

Parameters

sqlDataType
SqlDataType
precision
Int32
scale
Int32

Applies to

DataType(UserDefinedTableType)

Allows a DataType object to be created based on a UserDefinedTableType instance.

public DataType (Microsoft.SqlServer.Management.Smo.UserDefinedTableType userDefinedTableType);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.UserDefinedTableType -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (userDefinedTableType As UserDefinedTableType)

Parameters

userDefinedTableType
UserDefinedTableType

Applies to

DataType(UserDefinedDataType)

Allows a DataType object to be created based on a UserDefinedDataType instance.

public DataType (Microsoft.SqlServer.Management.Smo.UserDefinedDataType userDefinedDataType);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.UserDefinedDataType -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (userDefinedDataType As UserDefinedDataType)

Parameters

userDefinedDataType
UserDefinedDataType

Applies to

DataType(SqlDataType)

Creates a new DataType object. The sqlDataType specifies the SQL Server data type.

public DataType (Microsoft.SqlServer.Management.Smo.SqlDataType sqlDataType);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.SqlDataType -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (sqlDataType As SqlDataType)

Parameters

sqlDataType
SqlDataType

Applies to

DataType(UserDefinedType)

Allows a DataType object to be created based on a UserDefinedType instance.

public DataType (Microsoft.SqlServer.Management.Smo.UserDefinedType userDefinedType);
new Microsoft.SqlServer.Management.Smo.DataType : Microsoft.SqlServer.Management.Smo.UserDefinedType -> Microsoft.SqlServer.Management.Smo.DataType
Public Sub New (userDefinedType As UserDefinedType)

Parameters

userDefinedType
UserDefinedType

Applies to