通过

Table.RowCount 属性

  • 项目

Gets the number of rows in the table.

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCount As Long 
    Get
用法
Dim instance As Table 
Dim value As Long 

value = instance.RowCount

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public long RowCount { get; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property long long RowCount {
    long long get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member RowCount : int64

function get RowCount () : long

属性值

类型：System.Int64
An Int64 value that specifies the number of rows in the table.

示例

The following code example displays the number of rows contained in each table of the AdventureWorks2012 database.

C#

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

foreach (Table tb in db.Tables) 
{
   Console.WriteLine("The " + tb.Name + " contains " + tb.RowCount + " rows.");
}

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 "conains" $tb.RowCount "rows."
}

请参阅

参考

Table 类

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

表

CREATE TABLE (Transact-SQL)