Based on recent article about getting SQL Server table columns information, I decided to create a function “Get-dbTableColumns.ps1” and posted into the Microsoft Scritp Gallery. I use some of our favorite community tools from Chad Miller and Pinal Dave to bring in a practical and useful command.
So, checked it out at, “Get database table columns list”: http://gallery.technet.microsoft.com/scriptcenter/21c90399-d408-428d-92a5-902e037fdd9b
Instructions are included.
Hint: Want to save result to a text file? Try…
Get-dbTableColumns -DatabaseName YourDbName | Out-File -FilePath c:\TableInfo.txt
Enjoy!