Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

-Schema parameter not available for Get-DbaDbView command #9445

Closed
JoelMiller74 opened this issue Aug 12, 2024 · 0 comments · Fixed by #9475
Closed

-Schema parameter not available for Get-DbaDbView command #9445

JoelMiller74 opened this issue Aug 12, 2024 · 0 comments · Fixed by #9475
Assignees
Labels

Comments

@JoelMiller74
Copy link

Summarize Functionality

I would like to export all tables, stored procedures, and views in a specific schema (landing) from a database. The commands Get-DbaDbTable and Get-DbaDbStoredProcedure both have a parameter to pass in the schema to return objects for. However, the command Get-DbaDbView does not allow you to pass a schema parameter like the other commands. This will provide consistency and provide needed functionality. This might be able to be done by chaining some other commands together, but adding this parameter will provide consistency in how the commands work.

Is there a command that is similiar or close to what you are looking for?

Yes

Technical Details

Get-DbaDbTable -SqlInstance Server1 -Database MyDB -Schema schema1
Get-DbaDbStoredProcedure -SqlInstance Server1 -Database MyDB  -Schema schema1
Get-DbaDbView -SqlInstance Server1 -Database MyDB  -Schema schema1
@JoelMiller74 JoelMiller74 added feature triage required New issue that has not been reviewed by maintainers labels Aug 12, 2024
@niphlod niphlod self-assigned this Sep 26, 2024
@niphlod niphlod removed the triage required New issue that has not been reviewed by maintainers label Sep 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants