Get-DacColumn

SYNOPSIS

Returns columns of a table or view.

SYNTAX

Get-DacColumn -Object <TSqlObject> [[-Name] <String>] [<CommonParameters>]

DESCRIPTION

Provides a column object to access it’s definition.

EXAMPLES

Example 1

PS C:\> Import-DacModel -Path ./WideWorldImporters.dacpac | Get-DacTable -Name '[Application].[Cities]' | Get-DacColumn -Name '[Application].[Cities].[CityID]'

Schema      Name                            ObjectType
------      ----                            ----------
Application [Application].[Cities].[CityID] Microsoft.SqlServer.Dac.Model.ModelTypeClass

Example 2

PS C:\> Import-DacModel -Path ./WideWorldImporters.dacpac | Get-DacView -Name '[Website].[Customers]' | Get-DacColumn -Name '[Website].[Customers].[CustomerID]'

Schema  Name                               ObjectType
------  ----                               ----------
Website [Website].[Customers].[CustomerID] Microsoft.SqlServer.Dac.Model.ModelTypeClass

PARAMETERS

-Name

Specifies a filter on the column name.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Object

Specifies the table or view to get the columns from. The ObjectType must be Table or View.

Type: TSqlObject
Parameter Sets: (All)
Aliases: Table

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

Microsoft.SqlServer.Dac.Model.TSqlObject

OUTPUTS

Microsoft.SqlServer.Dac.Model.TSqlObject

ObjectType will be Column.

NOTES

RELATED LINKS

TSqlObject