Delete multiple databases in SQL service using a filter

Below is a query to delete multiple databases where the database name matches the string specified:

Replace the <insert database name string> with the database name filter.

use master
go
declare @dbnames nvarchar(max)
declare @statement nvarchar(max)
set @dbnames = ”
set @statement = ”
select @dbnames = @dbnames + ‘,[‘ + name + ‘]’ from sys.databases where name like ‘<insert database name string>%’
if len(@dbnames) = 0
begin
print ‘no databases to drop’
end
else
begin
set @statement = ‘drop database ‘ + substring(@dbnames, 2, len(@dbnames))
print @statement
exec sp_executesql @statement
end