Index.FilterDefinition 屬性

Gets or sets the String value that contains the definition for the filter.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Deploy)> _
Public Property FilterDefinition As String 
    Get 
    Set
'用途
Dim instance As Index 
Dim value As String 

value = instance.FilterDefinition

instance.FilterDefinition = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)]
public string FilterDefinition { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Deploy)]
public:
property String^ FilterDefinition {
    String^ get ();
    void set (String^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Deploy)>]
member FilterDefinition : string with get, set

function get FilterDefinition () : String 
function set FilterDefinition (value : String)

屬性值

型別：System.String
A String value that specifies the definition of the filter.

備註

The required format for the filter predicate is specified in the CREATE INDEX topic.

範例

建立、改變和移除索引

請參閱

參考

Index 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

CREATE INDEX (Transact-SQL)