• Article

Table.RowCount Property

Gets the number of rows in the table.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCount As Long
    Get
'Usage
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

Property Value

Type: System.Int64
An Int64 value that specifies the number of rows in the table.

Examples

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

C#

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

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("AdventureWorks2008R2")

Foreach ($tb in $db.Tables) 
{
   Write-Host "The" $tb.Name "conains" $tb.RowCount "rows."
}