• Article

ReplicationTable.HasSparseColumn Property

Gets whether the table has a column with the SPARSE attribute.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public ReadOnly Property HasSparseColumn As Boolean
    Get
'Usage
Dim instance As ReplicationTable
Dim value As Boolean

value = instance.HasSparseColumn

public bool HasSparseColumn { get; }

public:
property bool HasSparseColumn {
    bool get ();
}

member HasSparseColumn : bool

function get HasSparseColumn () : boolean

Property Value

Type: System.Boolean
A Boolean value. If true, the table has at least one column with the SPARSE attribute. If false, the table does not have a column with the SPARSE attribute.

Remarks

The HasSparseColumn property can be retrieved by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

The HasSparseColumn property is available with SQL Server 2008.