Cannot DROP FUNCTION because it is being referenced by object

Question

I got this error while trying to drop some User Defined Functions.

Msg 3729, Level 16, State 1, Line 13
Cannot DROP FUNCTION 'dbo.testfn2' because it is being referenced by object 'testtable2'.

Msg 3729, Level 16, State 1, Line 14
Cannot DROP FUNCTION 'dbo.testfn' because it is being referenced 
by object 'DF__testtable__idc__5CD6CB2B'.

One reason for this error was some columns were using the function in their default constraints.

I tried removing all default constraints.

But there are reasons other than this.

What are the other possibilities?

Answer 1

To show dependencies you can use sp_depends procedure:

exec sp_depends 'dbo.YourFunc'

Or, call sys.dm_sql_referencing_entities table valued function:

SELECT * FROM sys.dm_sql_referencing_entities('dbo.YourFunc','OBJECT')