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 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.