This topic has not yet been rated - Rate this topic

Table.DataSpaceUsed Property

SQL Server 2008 R2

Gets the storage space used by the rows of the referenced table in kilobytes.

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

Syntax

C++

JScript

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

Property Value

Type: System.Double
A Float64 value that specifies the storage space of the rows of data in the table, in kilobytes.

Remarks

The value is the actual amount of disk space that is required to store the row data of the referenced table. SQL Server can allocate additional, unused space to a Table object.

Examples

The following code example shows how to display the amount of storage space used by each table in the AdventureWorks2008R2 database.

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

foreach (Table tb in db.Tables)
{
   Console.WriteLine("The " + tb.Name + " table is " + tb.DataSpaceUsed.ToString() + " KB in size.");
}

Powershell

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

Foreach ($tb in $db.Tables)
{
   Write-Host "The" $tb.Name "table is" $tb.DataSpaceUsed "KB in size."
}

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

CREATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD