Index.HasFilter Property

Gets the Boolean property value that specifies whether the index has a filter defined for a range of index values.

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)> _
Public ReadOnly Property HasFilter As Boolean 
    Get
'Usage
Dim instance As Index 
Dim value As Boolean 

value = instance.HasFilter

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property bool HasFilter {
    bool get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member HasFilter : bool

function get HasFilter () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether the index has a filter. If True, the index has a filter. Otherwise, False (default).

Remarks

The filter is defined by the filter predicate in the FilterDefinition property.

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)