#PSTip Deleting extended properties on database objects using SMO

Note: This tip requires PowerShell 2.0 or above.

In earlier tips, we looked at how to add, read and update the extended properties of a SQL database. In this tip we will see how we can delete them, in-case we need to do some cleanup.

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
$server = New-Object Microsoft.SqlServer.Management.Smo.Server $env:COMPUTERNAME
$server.Databases["sqlchow"].ExtendedProperties | Select Name, Value, State

Name          Value                           State
----          -----                           -----
Change made   Set recovery model to simple Existing
Change madeby Crack-Monkey                 Existing

#drop the extended property
$server.Databases["sqlchow"].ExtendedProperties["Change made"].Drop()
$server.Databases["sqlchow"].ExtendedProperties | Select Name, Value, State

Name          Value           State
----          -----           -----
Change madeby Crack-Monkey Existing
Filed in: Columns, Tips and Tricks Tags: , , ,
© 2018 PowerShell Magazine. All rights reserved. XHTML / CSS Valid.
Proudly designed by Theme Junkie.
%d bloggers like this: