Propriété Table.RowCount
Gets the number of rows in the table.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public ReadOnly Property RowCount As Long
Get
'Utilisation
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
Valeur de propriété
Type : System.Int64
An Int64 value that specifies the number of rows in the table.
Exemples
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."
}
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo