ExtendedProperty

Add-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Add-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Adds extended properties to SQL Server objects for metadata storage and documentation Description Creates custom metadata properties on SQL Server objects to store documentation, version information, business context, or compliance tags. Extended properties are stored in the database system catalogs and don’t affect object performance but provide valuable context for DBAs managing complex environments. This command accepts piped input from any dbatools Get-Dba* command, making it easy to bulk-apply properties across multiple objects.

Get-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Get-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves custom metadata and documentation stored as extended properties on SQL Server objects Description Retrieves extended properties that contain custom metadata, documentation, and business descriptions attached to SQL Server objects. Extended properties are commonly used by DBAs and developers to store object documentation, version information, business rules, and compliance notes directly within the database schema. This function discovers what documentation and metadata exists across your database objects, making it invaluable for database documentation audits, compliance reporting, and understanding legacy systems.