Try:
SELECT * FROM information_schema.tables
"this is show all table i want to show all database"
Oops! :O
Dim con As New SqlConnection("Data Source=GRIFFPC\SQLEXPRESS;Integrated Security=True")
con.Open()
Dim cmd As New SqlCommand("sp_databases", con)
cmd.CommandType = CommandType.StoredProcedure
Dim read As SqlDataReader = cmd.ExecuteReader()
While read.Read()
Console.WriteLine(DirectCast(read("DATABASE_NAME"), String))
End While
You will need to change teh instance name, and may need a UID/Password combo instead of Integrated Security.