Udostępnij przez


UserDefinedDataType.VariableLength Property

Gets the Boolean property value that specifies whether the user-defined data type is variable in length.

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

Syntax

'Deklaracja
<SfcPropertyAttribute> _
Public ReadOnly Property VariableLength As Boolean
[SfcPropertyAttribute] 
public bool VariableLength { get; }
[SfcPropertyAttribute] 
public:
property bool VariableLength {
    bool get ();
}
/** @property */
public boolean get_VariableLength ()
public function get VariableLength () : boolean

Property Value

A Boolean value that specifies whether the user-defined data type is variable in length. If True, the user-defined data type represents a data type that can vary in length, such as varchar(4). If False (default), the user-defined data type represents a data type that cannot vary in length, such as char(4). A 2-character value retrieved from a user-defined data type defined as varchar(4) is returned as 2 characters. However, the same value retrieved from a user-defined data type defined as char(4) is padded and returned as 4 characters.

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.

Target Platforms

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