Generate script to drop all schema objects

Script-DropSchemaObjects

SET NOCOUNT ON
DECLARE  @SchemaName NVARCHAR(100) = 'mipl'

SELECT 'DROP ' +
                CASE WHEN type IN ('P','PC') THEN 'PROCEDURE'
                        WHEN type =  'U' THEN 'TABLE'
                        WHEN type IN ('IF','TF','FN') THEN 'FUNCTION'
                        WHEN type = 'V' THEN 'VIEW'
                    END +
                ' ' +  QUOTENAME(SCHEMA_NAME(schema_id))+'.'+QUOTENAME(name)   as DropStatement
                FROM sys.objects
            WHERE schema_id = SCHEMA_ID(@SchemaName)
AND type IN('P','PC','U','IF','TF','FN','V')
ORDER BY  CASE WHEN type IN ('P','PC') THEN 4
                        WHEN type =  'U' THEN 3
                        WHEN type IN ('IF','TF','FN') THEN 1
                        WHEN type = 'V' THEN 2
                    END

SELECT 'DROP SCHEMA ' + QUOTENAME(@SchemaName) as DropStatement