Microsoft® SQL Server 2012 Unleashed

Getting Table Properties

Another common task is to get a row count of the tables in a particular database:

Click here to view code image

PS SQLSERVER:\SQL\<servername>\<instancename>\Databases\AdventureWorks2012\Tables> Get-ChildItem .|  Sort-Object -descending|Select-Object -First 10| Format-Table -autosize Name,RowCountNote

Note

An easy-to-remember alias for Get-ChildItem is basically dir.

In the preceding example using the AdventureWorks2012 database, the top 10 tables with the highest row count value are returned.

Note

The preceding example shows how many features are packaged within PowerShell, which applies not only to SQL tables, but also to all .NET objects. Simply using Get-Item on a particular table returns only the default properties ...