JanRomero

declare @sql nvarchar(max) =
    (select string_agg(concat('alter database ', quotename(name), ' set single_user with rollback immediate; drop database ', quotename(name), ';'), char(13))
     from sys.databases
     where database_id > 4);

EXEC sp_executesql @sql;