dbatools bring us a set of useful commands to manage sequence objects in SQL Server. In this article, we are going through the five new commands. The commands are shown below.
# get commands that have something to do with sequence within dbatools module Get-Command -Module dbatools -Name *sequence* <# CommandType Name Version Source ———– —- ——- —— Function Get-DbaDbSequence 1.1.14 dbatools Function New-DbaDbSequence 1.1.14 dbatools Function Remove-DbaDbSequence 1.1.14 dbatools Function Select-DbaDbSequenceNextValue 1.1.14 dbatools Function Set-DbaDbSequence 1.1.14 dbatools #> What’s a Sequence?
A user object called a sequence generates a series of numeric values based on specified criteria. While it