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. |