Try this assuming all databases are on the same instance.
DECLARE @DATABASE TABLE
(
ID INT IDENTITY(1, 1),
NAME VARCHAR(100)
)
INSERT INTO @DATABASE (NAME)
SELECT 'Adventure'
UNION ALL
SELECT 'TESTDB'
DECLARE @INDEX INT, @TOTAL INT, @DBNAME VARCHAR(100)
SELECT @INDEX = 1
SELECT @TOTAL = COUNT(*) FROM @DATABASE
WHILE @INDEX <= @TOTAL
BEGIN
SELECT @DBNAME = NAME
FROM @DATABASE
WHERE ID = @INDEX
SELECT 'USE ' + @DBNAME, @INDEX
EXECUTE ('USE ' + @DBNAME)
EXECUTE ('CREATE TABLE ' + @DBNAME + '..TEST1 (NAME VARCHAR(100)) ')
SET @INDEX = @INDEX + 1
END