Propriedade do RDL Table.RowCount

Artigo
04/26/2013

Gets the number of rows in the table.

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

Sintaxe

'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCount As Long 
    Get
'Uso
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

Valor da propriedade

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

Exemplos

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

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."
}

Consulte também

Referência

Table Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Tabelas

CREATE TABLE (Transact-SQL)

Compartilhar via