remove all user objects from master

remove-user-objects-from-master.sql

USE MASTER  
GO  
  
SET NOCOUNT ON  
GO  
  
SELECT N'ALTER TABLE  [' + schema_name([schema_id]) + N'].[' + object_name(parent_object_id) + N'] DROP ' + [name] command from sys.objects where [type] = 'F' AND is_ms_shipped <> 1  
UNION ALL  
SELECT 'GO' command  
UNION ALL  
SELECT N'DROP PROCEDURE [' + schema_name([schema_id]) + N'].[' + [name] + N']' command from sys.objects where [type] = 'P' AND is_ms_shipped <> 1  
UNION ALL  
SELECT 'GO' command  
UNION ALL  
SELECT N'DROP TABLE [' + schema_name([schema_id]) + N'].[' + [name] + N'] ' command from sys.objects where [type] = 'U' AND is_ms_shipped <> 1  
UNION ALL  
SELECT 'GO' command  
UNION ALL  
SELECT N'DROP VIEW [' + schema_name([schema_id]) + N'].[' + [name] + N'] ' command from sys.objects where [type] = 'V' AND is_ms_shipped <> 1  
UNION ALL  
SELECT 'GO' command  
UNION ALL  
SELECT N'DROP FUNCTION [' + schema_name([schema_id]) + N'].[' + [name] + N'] ' command from sys.objects where [type] = 'FN' AND is_ms_shipped <> 1  
UNION ALL  
SELECT 'GO' command  
UNION ALL  
SELECT N'DROP FUNCTION [' + schema_name([schema_id]) + N'].[' + [name] + N'] ' command from sys.objects where [type] = 'TF' AND is_ms_shipped <> 1  

-- You can verify the counts before and after using below query.

SELECT count(1)  
FROM master.sys.objects  
WHERE is_ms_shipped <> 1 AND TYPE IN ('U','P','FN','V','TF')