Propriedade do RDL Table.IndexSpaceUsed

Artigo
04/26/2013

Gets the space used by the index, in KB.

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

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property IndexSpaceUsed As Double 
    Get
'Uso
Dim instance As Table 
Dim value As Double 

value = instance.IndexSpaceUsed

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public double IndexSpaceUsed { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property double IndexSpaceUsed {
    double get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member IndexSpaceUsed : float

function get IndexSpaceUsed () : double

Valor da propriedade

Tipo: System.Double
A Float64 value that specifies space used by the index, in KB.

Exemplos

The following code example shows how to list the amount of index space used by each table in the AdventureWorks2012 database.

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

foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " table has uses " + tb.IndexSpaceUsed.ToString() + " KB of index space.");
}

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) 
{
   Write-Host "The" $tb.Name "table uses " $tb.IndexSpaceUsed " KB of index space."
}

Consulte também

Referência

Table Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Tabelas

CREATE TABLE (Transact-SQL)

Compartilhar via