Get-DbaDatabasePartitionScheme

Gets database Partition Schemes

Screenshots

dbatools - Get-DbaDatabasePartitionScheme

Examples

Gets all database Partition Schemes

Get-DbaDatabasePartitionScheme -SqlInstance sql2016

Gets the Partition Schemes for the db1 database

Get-DbaDatabasePartitionScheme -SqlInstance Server1 -Database db1

Gets the Partition Schemes for all databases except db1

Get-DbaDatabasePartitionScheme -SqlInstance Server1 -ExcludeDatabase db1

Gets the Partition Schemes for the databases on Sql1 and Sql2/sqlexpress

‘Sql1′,’Sql2/sqlexpress’ | Get-DbaDatabasePartitionScheme

Author

This command was created by Klaas Vandenberghe. You can find Klaas on Twitter and his blog.