PsDac connects DacFx and PowerShell. It gives you PowerShell Cmdlets with the power of Microsoft.SqlServer.DacFx.
Returns the tables of a model.
Get-DacTable [-Model] <TSqlModel> [[-Name] <String>] [<CommonParameters>]
Provides a table object to access it’s definition.
PS C:\> Import-DacModel -Path ./WideWorldImporters.dacpac | Get-DacTable -Name '[Application].[Cities]'
Schema Name ObjectType
------ ---- ----------
Application [Application].[Cities] Microsoft.SqlServer.Dac.Model.ModelTypeClass
Specifies the model to get the tables from.
Type: TSqlModel
Parameter Sets: (All)
Aliases:
Required: True
Position: 0
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False
Specifies a filter on the table name.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.