Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
VariableLength Property

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)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Matrix)]
public bool VariableLength { get; }

Property Value

Type: Boolean
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.

Community Additions

ADD
Show:
© 2015 Microsoft