TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Index.SpaceUsed Property

 

Gets or sets the disk space used to store the index data in kilobytes.

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

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

Property Value

Type: System.Double

An Int64 value that specifies the space used, in KB.

System_CAPS_noteNote

For indexes based on the UserDefinedTableType object the value of SpaceUsed property is zero. Also, if setting the property issues a dbcc command it will not be executed.

Return to top
Show:
© 2016 Microsoft