DataType.VarCharMax DataType.VarCharMax DataType.VarCharMax Property

Definition

Gets a data type that specifies the VarCharMax definition used in the data type.

public:
 static property Microsoft::SqlServer::Management::Smo::DataType ^ VarCharMax { Microsoft::SqlServer::Management::Smo::DataType ^ get(); };
public static Microsoft.SqlServer.Management.Smo.DataType VarCharMax { get; }
Public Shared ReadOnly Property VarCharMax As DataType
Property Value

A DataType object value that specifies a VarCharMax definition in the data type.

Examples

Visual Basic

Dim dt As DataType  
dt = New DataType(SqlDataType.VarCharMax)  

PowerShell

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

Remarks

This data type allows storage of up to a maximum of 2GB of data. You can use the VarCharMax data type as a parameter in stored procedures and string functions. However, you cannot use this data type in the key column of an index.

Applies to