DataType.VarCharMax Property
Gets a data type that specifies the VarCharMax definition used in the data type.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Shared ReadOnly Property VarCharMax As DataType
Get
'Usage
Dim value As DataType
value = DataType.VarCharMax
public static DataType VarCharMax { get; }
public:
static property DataType^ VarCharMax {
DataType^ get ();
}
static member VarCharMax : DataType
static function get VarCharMax () : DataType
Property Value
Type: Microsoft.SqlServer.Management.Smo.DataType
A DataType object value that specifies a VarCharMax definition in the data type.
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.
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)