Udf | dbatools | Command-line superpowers for SQL Server automation

Get-DbaDbUdf

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaDbUdf View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves User Defined Functions and User Defined Aggregates from SQL Server databases with filtering and metadata Description Retrieves all User Defined Functions (UDFs) and User Defined Aggregates from one or more SQL Server databases, returning detailed metadata including schema, creation dates, and data types. This function helps DBAs inventory custom database logic, analyze code dependencies during migrations, and audit user-created functions for security or performance reviews.

Remove-DbaDbUdf

Mikey Bronowski (@MikeyBronowski), bronowski.it

Remove-DbaDbUdf View Source Mikey Bronowski (@MikeyBronowski), bronowski.it Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Removes user-defined functions and user-defined aggregates from SQL Server databases. Description Removes user-defined functions and user-defined aggregates from specified databases, providing a clean way to drop obsolete or unwanted UDFs and UDAs without manual T-SQL scripting. This function is particularly useful during database cleanup operations, code refactoring projects, or when removing deprecated functions that are no longer needed.