A PowerShell snippet to call SQL command to remove all DBs starting with 'Platform'

RemoveDatabasesByPrefix.ps1

Invoke-Sqlcmd -ServerInstance "(local)" -Query "`
            DECLARE @dbnames NVARCHAR(MAX) SET @dbnames = ''`
            DECLARE @alter NVARCHAR(MAX) SET @alter = ''`
            DECLARE @statement NVARCHAR(MAX) SET @statement = ''`
			`
            SELECT @dbnames = @dbnames + ',[' + name + ']' FROM sys.databases WHERE NAME LIKE 'Platform_%'`
            SELECT @alter = @alter + 'ALTER DATABASE [' + name + '] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;'  FROM sys.databases WHERE NAME LIKE 'Platform_%'`
            IF LEN(@dbnames) > 0`
            BEGIN`
                   EXEC sp_executesql @alter`
                   SET @statement = 'drop database ' + SUBSTRING(@dbnames, 2, LEN(@dbnames))`
                   PRINT @statement`
                   EXEC sp_executesql @statement`
            END"