Bagikan melalui


Column.IsSparse Property

Gets or sets the Boolean property value that specifies whether this is a sparse column. For more information about sparse columns, see Use Sparse Columns.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property IsSparse As Boolean 
    Get 
    Set
'Usage
Dim instance As Column 
Dim value As Boolean 

value = instance.IsSparse

instance.IsSparse = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool IsSparse { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool IsSparse {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member IsSparse : bool with get, set
function get IsSparse () : boolean 
function set IsSparse (value : boolean)

Property Value

Type: System.Boolean
A Boolean property value that specifies whether column value is sparse. If True, the column is sparse. Otherwise, False (default).

Examples

Working with Database Objects

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace