UserDefinedDataType.VariableLength Property

Article
12/15/2008

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

Espace de noms: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
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

Valeur de propriété

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.

Notes

Cet espace de noms, cette classe ou ce membre est pris en charge uniquement par la version 2.0 de Microsoft .NET Framework.

Exemple

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

Sécurité des threads

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.

Plateformes

Plateformes de développement

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Plateformes cibles

Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.

Voir aussi

Référence

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

Autres ressources

Types de données (Moteur de base de données)
CREATE TYPE (Transact-SQL)

Partager via