Database.DataSpaceUsage Property
Gets the space used by the data in the database.
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
語法
'宣告
Public ReadOnly Property DataSpaceUsage As Double
public double DataSpaceUsage { get; }
public:
property double DataSpaceUsage {
double get ();
}
/** @property */
public double get_DataSpaceUsage ()
public function get DataSpaceUsage () : double
屬性值
A Float64 value that specifies the amount of space used by the data, in kilobytes.
備註
更新的文字:2006 年 7 月 17 日
只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。
範例
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")
'Display size and space information for the database.
Console.WriteLine("data space usage (KB): " + _
db.DataSpaceUsage.ToString)
Console.WriteLine("index space usage (KB): " + _
db.IndexSpaceUsage.ToString)
Console.WriteLine("space available (KB): " + _
db.SpaceAvailable.ToString)
Console.WriteLine("database size (MB): " + _
db.Size.ToString)
執行緒安全性
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
平台
開發平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
目標平台
如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。
請參閱
參考
Database Class
Database Members
Microsoft.SqlServer.Management.Smo Namespace
其他資源
How to: Create, Alter, and Remove a Database in Visual Basic .NET
Creating, Altering, and Removing Databases
CREATE DATABASE (Transact-SQL)