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 AzureDevOpsConnection class.
C#
String connectionString = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;"; using (AzureDevOpsConnection conn = new AzureDevOpsConnection(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 = "AuthScheme=Basic;Organization=MyAzureDevOpsOrganization;Catalog=Project_dev;Schema=Project;PersonalAccessToken=MyPAT;" Using conn As New AzureDevOpsConnection(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. |