sql script to drop database in batch :

CREATE TABLE #databaseNames(name varchar(100)NOTNULL,

db_size varchar(50),ownervarchar(50),dbidint,

created date,statustext,compatibility_levelint);

INSERT #databaseNamesexecsp_helpdb;

-- Just modify the string after like below:

DECLARE dropCur CURSORFOR SELECT name FROM #databaseNames WHERE name like '[' + ‘NewDB6%' + ']';

OPEN dropCur;

 DECLARE @dbName nvarchar(100); 

FETCH NEXTFROM dropCur INTO @dbName;

 DECLARE@statement nvarchar(200);

 

WHILE @@FETCH_STATUS= 0

BEGIN

SET @statement ='DROP DATABASE '+ @dbName;EXECsp_executesql@statement;FETCHNEXTFROM dropCur INTO @dbName;

END

CLOSE dropCur;

 DEALLOCATE dropCur;

 DROP TABLE #databaseNames

;