ExtendedProperty

Add-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Add-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.

Get-DbaExtendedProperty

Chrissy LeMaire (@cl), netnerds.net

Get-DbaExtendedProperty View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs 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.