Users
The Users schema collection lists all users in the database.
Retrieving the Users Listing
To retrieve the Users 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("Users");
foreach (DataRow row in databaseSchema.Rows) {
Console.WriteLine(row["User"]);
}
}
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("Users")
For Each row As DataRow In databaseSchema.Rows
Console.WriteLine(row("User"))
Next
End Using
Columns Returned
The Users schema collection returns the following columns.
Column Name | Data Type | Description |
User | System.String | The user name. |
Domain | System.String | The domain of the user. |
Annotation | System.String | The annotations for the user. |