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 AmazonDynamoDBConnection class.
C#
String connectionString = "AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;"; using (AmazonDynamoDBConnection conn = new AmazonDynamoDBConnection(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 = "AWS Access Key=xxx;AWS Secret Key=xxx;Domain=amazonaws.com;AWS Region=OREGON;" Using conn As New AmazonDynamoDBConnection(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. |