Table.IsIndexable 屬性

發行項
04/26/2013

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

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property IsIndexable As Boolean 
    Get
'用途
Dim instance As Table 
Dim value As Boolean 

value = instance.IsIndexable

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

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

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

function get IsIndexable () : boolean

屬性值

型別：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).

備註

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

範例

The following code example shows how to list all of the indexable tables in the AdventureWorks2012 database.

Server srv = new Server("(local)");
Database db = srv.Databases["AdventureWorks2012"];

foreach (Table tb in db.Tables) 
{
   if (tb.IsIndexable == True)
   {
      Console.WriteLine("The " + tb.Name + " table is indexable.");
   }
}

Powershell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

Foreach ($tb in $db.Tables) 
{
   If ($tb.IsIndexable -eq $TRUE)
   {
      Write-Host "The" $tb.Name "table is indexable."
   }
}