SQL SERVER | Cancellare tutte le tabelle di un database

DECLARE @tableSchema VARCHAR(5) = 'dbo'
DECLARE @dbName VARCHAR(50) = 'TEST'

SELECT CONCAT('USE [', @dbName, ']') AS Obj2Drop
UNION 
SELECT CONCAT('DROP TABLE [', TABLE_NAME, ']') AS Obj2Drop ---TABLES---
FROM information_schema.tables
WHERE TABLE_SCHEMA = @tableSchema AND TABLE_CATALOG = @dbName
UNION
SELECT CONCAT('DROP VIEW [', TABLE_NAME, ']') AS Obj2Drop ---VIEWS---
FROM information_schema.views
WHERE TABLE_SCHEMA = @tableSchema AND TABLE_CATALOG = @dbName
UNION
SELECT CONCAT('DROP ', ROUTINE_TYPE, ' [', SPECIFIC_NAME, ']') AS Obj2Drop ---STORED E FUNCTIONS---
FROM information_schema.routines
WHERE SPECIFIC_SCHEMA = @tableSchema AND SPECIFIC_CATALOG = @dbName
ORDER BY Obj2Drop DESC