Partilhar via


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

'Declaration
Public ReadOnly Property VariableLength As Boolean
public bool VariableLength { get; }
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 type defined as char(4) is padded and returned as 4 characters.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Construct a DataType Object by Using the Default Constructor in Visual Basic .NET

How to: Construct a DataType Object with the Specification in the Constructor in Visual Basic .NET

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 2005.

Target Platforms

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

See Also

Reference

UserDefinedDataType Class
UserDefinedDataType Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Data Types (Database Engine)
CREATE TYPE (Transact-SQL)