Get-DbaDatabaseUdf

Gets database User Defined Functions

Screenshots

dbatools  -Get-DbaDatabaseUdf

Examples

Gets all database User Defined Functions

Get-DbaDatabaseUdf -SqlInstance sql2016

Gets the User Defined Functions for the db1 database

Get-DbaDatabaseUdf -SqlInstance Server1 -Database db1

Gets the User Defined Functions for all databases except db1

Get-DbaDatabaseUdf -SqlInstance Server1 -ExcludeDatabase db1

Gets the User Defined Functions for all databases that are not system objects (there can be 100+ system User Defined Functions in each DB)

Get-DbaDatabaseUdf -SqlInstance Server1 -ExcludeSystemUdf

Gets the User Defined Functions for the databases on Sql1 and Sql2/sqlexpress

‘Sql1′,’Sql2/sqlexpress’ | Get-DbaDatabaseUdf

Author

This command was created by Klaas Vandenberghe. You can find Klaas on Twitter and his blog.