Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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
Microsoft.SqlServer.Management.Smo Namespace