Public/Get-FoxProColumnMetaData.ps1
|
function Get-FoxProColumnMetaData { <# .SYNOPSIS Displays metadata for FoxPro columns .DESCRIPTION Displays metadata for FoxPro columns .PARAMETER DataSource Which FoxPro location is of interest? .PARAMETER TableName What is the name of the table(s) of interest? Null means 'all tables'. .PARAMETER ColumnName What is the name of the column(s) of interest? Null means 'all tables'. .EXAMPLE Get-FoxProColumnMetaData -datasource '\\server\share\path' # Shows all of the columns in all of the tables at that location. .EXAMPLE $Path = 'C:\Program Files (x86)\Microsoft Visual FoxPro OLE DB Provider\Samples\Northwind' Get-FoxProColumnMetaData -datasource $Path -TableName 'employees' # Shows the column information for all of the columns in the table named 'employees'. .EXAMPLE Get-FoxProColumnMetaData -datasource '\\server\share\path' -ColumnName "fname" Shows the column information for the column 'fname' in all tables found at that location. This can be very handy to look for differences in column definitions. #> param ( [Parameter(Mandatory = $True, ValueFromPipeline = $True, ValueFromPipelinebyPropertyName = $True)] $Datasource, $TableName, $ColumnName ) try { $cn = Get-FoxProConnection -DataSource $Datasource # Get-OleDbColumnMetadata doesn't provide for restricting by column name, so we will do that here. # Dbase doesn't support many of the metadata columns here, so we will restrict the output Get-OleDbColumnMetadata -Connection $cn | Where-Object { $_.ColumnName -eq $ColumnName -or $Null -eq $ColumnName } | Where-Object { $_.TableName -eq $TableName -or $Null -eq $TableName } | Select-Object TableName, ColumnName, OrdinalPosition, ColumnFlags, IsNullable, DataType, DataTypeDescription, NumericPrecision, NumericScale, CharacterMaximumLength, CharacterOctetLength # TableCatalog, TableScema # ColumnHasDefault, ColumnDefault, # CharacterSetCatalog, CharacterSetSchema, CharacterSetName, # CollationCatalog, CollationSchema, CollationName, # DomainCatalog, DomainSchema, DomainName, # IsComputed } finally { $cn.Close() $cn.Dispose() } } |