Sdílet prostřednictvím

  • Článek

Table.IsIndexable Property

Gets the Boolean property value that specifies whether an index can be placed on the table.

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

Syntax

'Declaration
<SfcPropertyAttribute> _
Public ReadOnly Property IsIndexable As Boolean
    Get
'Usage
Dim instance As Table
Dim value As Boolean

value = instance.IsIndexable

[SfcPropertyAttribute]
public bool IsIndexable { get; }

[SfcPropertyAttribute]
public:
property bool IsIndexable {
    bool get ();
}

[<SfcPropertyAttribute>]
member IsIndexable : bool

function get IsIndexable () : boolean

Property Value

Type: System.Boolean
A Boolean value that specifies whether an index can be placed on the table.
If True, an index can be placed on the table. Otherwise, False (default).

Remarks

Most tables can support an index. However, some that cannot support an index because of the nature of the data.