ExtendedProperties

Remove-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Remove-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Removes custom metadata and documentation stored as extended properties from SQL Server objects Description Removes extended properties that contain custom metadata, documentation, and business descriptions from SQL Server objects. Extended properties are commonly used to store object documentation, version information, compliance tags, and business rules directly within the database schema. This function accepts piped input from Get-DbaExtendedProperty, making it easy to remove outdated documentation, clean up deprecated metadata, or bulk-remove properties during database restructuring projects.

Set-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Set-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Updates the value of existing extended properties on SQL Server database objects Description Updates the value of existing extended properties on SQL Server database objects. Extended properties store custom metadata like application versions, documentation, or business rules directly with database objects. This function modifies the values of properties that already exist, making it useful for maintaining application version numbers, updating documentation, or batch-modifying metadata across multiple objects.