O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting Table Properties

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

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required