Delete all function from database

Question

How can I delete all function from my database using sql-script. I tried:

declare @nm varchar(100)
select @nm = name from sysobjects where type = 'FN'
exec('drop function ' + @nm)

And I put in into the loop but it not delete all function. Please help

Please show us the loop. Also, when you say "not delete all function" what functions are left? How many are deleted? — chrisl08, Sep 10 '15 at 16:56

score 17 · Accepted Answer · answered Sep 10 '15 at 17:16

17

Declare @sql NVARCHAR(MAX) = N'';

SELECT @sql = @sql + N' DROP FUNCTION ' 
                   + QUOTENAME(SCHEMA_NAME(schema_id)) 
                   + N'.' + QUOTENAME(name)
FROM sys.objects
WHERE type_desc LIKE '%FUNCTION%';

Exec sp_executesql @sql
GO

answered Sep 10 '15 at 17:16

M.Ali

67,945
13
101
127

You can use syntax `DROP FUNCTION functionName; – stacksonstacksonstacks May 07 '23 at 04:02

Delete all function from database

1 Answers1