Get Drop Commend to all Procedure & Functions

SELECT 'Drop '+
CASE
WHEN TYPE='P' THEN 'procedure'
ELSE 'function'
END +' '+ NAME FROM sys.all_objects
WHERE TYPE in ('p','fn','tvn')
AND is_ms_shipped=0