Get-DbaDbSequence Remove requirement to provide the name, database, etc - more fexible

[MikeyBronowski]

Summary of new feature

• Clear/concise description of what the problem is that the new feature can solve.

Currently the function requires very specific information in order to return sequence. Would be great if we could have something like Get-DbaDbRole where providing the SqlInstance it gets all the objects, but we could also use -Name, -Schema filters to filter out the results.

Additionally change the output, so it can be use in the piping into the Remove-DbaDbSequence #7286

Proposed technical details (if applicable)

Follow the approach in Get-DbaDbRole.

Get-DbaDbSequence -SqlInstance localhost
should return all the sequences on the server without a need to specify the Name/Database/Schema parameters

Latest version of dbatools as of writing

• Please provide the latest released version of dbatools module.
  1.0.147