Tables
The Tables schema collection lists all tables in the database, including views.
Retrieving the Table Listing
To retrieve the Tables schema collection, call the GetSchema method of the EmailConnection class.
C#
String connectionString = "Port=993;Server=outlook.office365.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.office365.com;"; using (EmailConnection conn = new EmailConnection(connectionString)) { conn.Open(); DataTable databaseSchema = conn.GetSchema("Tables"); foreach (DataRow row in databaseSchema.Rows) { Console.WriteLine(row["TABLE_NAME"]); } }
VB.NET
Dim connectionString As String = "Port=993;Server=outlook.office365.com;Password=password;User=user;Protocol=IMAP;SMTP Port=587;SMTP Server=smtp.office365.com;" Using conn As New EmailConnection(connectionString) conn.Open() Dim databaseSchema As DataTable = conn.GetSchema("Tables") For Each row As DataRow In databaseSchema.Rows Console.WriteLine(row("TABLE_NAME")) Next End Using
Columns Returned
The Tables schema collection returns the following columns.
Column Name | Data Type | Description |
TABLE_CATALOG | System.String | The database that contains the table. |
TABLE_SCHEMA | System.String | The schema that contains the table. |
TABLE_NAME | System.String | The table name. |
TABLE_TYPE | System.String | The table type. |