ÿþ<html> <head> <title>Get-SqlInformation_Schema.Columns</title> </head> <body> <h1>Get-SqlInformation_Schema.Columns</h1> <div>Returns the result set from INFORMATION_SCHEMA.Columns for the specified database(s).</div> <h2> Syntax </h2> <code>Get-SqlInformation_Schema.Columns [-database] &lt;Database&gt; [[-tblname] &lt;String&gt;] [[-colname] &lt;String&gt;] [&lt;CommonParameters&gt;]</code> <h2> Detailed Description </h2> <div> The Get-SqlInformation_Schema.Columns function returns the result set from Information_Schema.Columns for the specified database(s). </div> <h2> Related Commands </h2> <div> * <a href='Get-SqlInformation_Schema.Columns.htm'>Get-SqlInformation_Schema.Columns</a><br/> </div> <h2> Parameters </h2> <table border='1'> <tr> <th>Name</th> <th>Description</th> <th>Required?</th> <th>Pipeline Input</th> <th>Default Value</th> </tr> <tr valign='top'> <td>database&nbsp;</td> <td>&nbsp;</td> <td>true&nbsp;</td> <td>true (ByValue)&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>tblname&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> <tr valign='top'> <td>colname&nbsp;</td> <td>&nbsp;</td> <td>false&nbsp;</td> <td>false&nbsp;</td> <td>&nbsp;</td> </tr> </table> <h2> Input Type </h2> <div>Microsoft.SqlServer.Management.Smo.Database You can pipe Database objects to Get-SqlInformation_Schema.Columns</div> <h2> Return Values </h2> <div>System.Data.DataRow Get-SqlInformation_Schema.Columns returns an array of System.Data.DataRow.</div> <h2> Examples </h2> <h3> EXAMPLE 1</h3> <pre>Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Columns</pre> <div>This command returns the result set from INFORMATION_SCHEMA.Columns for the pubs database.</div> <h3> EXAMPLE 2</h3> <pre>Get-SqlDatabase "Z002\sql2k8" "pubs" | Get-Information_Schema.Columns -tblname "authors" -colname "au_fname"</pre> <div>This command returns the result set from INFORMATION_SCHEMA.Columns for the pubs database where the table name is like authors and the column name is like au_fname.</div> </body> </html>