Get list of databases from Sql Server

SELECT name
FROM master..sysdatabases

EXEC sp_databases

SELECT [name]
FROM master.dbo.sysdatabases
WHERE dbid > 6

WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');

select name from master.sys.databases where owner_sid>1;

Dim server As New Microsoft.SqlServer.Management.Smo.Server("localhost")
For Each db As Database In server.Databases
    Console.WriteLine(db.Name)
Next