Databases

The Databases schema collection lists all the available databases.

Retrieving the Database Listing

To retrieve the Databases schema collection, call the GetSchema method of the CompositeConnection class.

C#

String connectionString = "Host=myHost;Domain=myDomain;DataSource=myDataSource;User=myUser;Password=myPassword";

using (CompositeConnection connection = new CompositeConnection(connectionString)) {

  connection.Open();

  DataTable databaseSchema = connection.GetSchema("Databases");

  foreach (DataRow row in databaseSchema.Rows) {

    Console.WriteLine(row["Database"]);

  }

}

VB.NET

 

Dim connectionString As String = "Host=myHost;Domain=myDomain;DataSource=myDataSource;User=myUser;Password=myPassword"

Using connection As New CompositeConnection(connectionString)

  connection.Open()

  Dim databaseSchema As DataTable = connection.GetSchema("Databases")

  For Each row As DataRow In databaseSchema.Rows

    Console.WriteLine(row("Database"))

  Next

End Using

Columns Returned

The Databases schema collection returns the following columns.

Column Name	Data Type	Description
Database	System.String	The database name.
Type	System.String	The database type.
Owner	System.String	The owner of the database.