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 QuickBaseConnection class.
C#
String connectionString = "[email protected];Password=test_1234;Domain=test.quickbase.com;ApplicationToken='bwkxrb5da2wn57bzfh9xn24';"; using (QuickBaseConnection conn = new QuickBaseConnection(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 = "[email protected];Password=test_1234;Domain=test.quickbase.com;ApplicationToken='bwkxrb5da2wn57bzfh9xn24';" Using conn As New QuickBaseConnection(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. |