To list all the table names from a Windows Azure storage account, you need to call the ListTable() function of the CloudTableClient class. To start with, first you need to
add the below namespaces.
Then create a storage account as below,
Make sure to put your own connection string to azure storage to parse. Next you
need to create instance of table client
Once a tableclient is created you can list all the tables by making call to
ListTables() method.
For your reference, the full source code to fetch all the tables name from a Windows
Azure Storage account is given below,
using
System;
using
System.Collections.Generic;
using
System.Linq;
using
Microsoft.WindowsAzure.StorageClient;
using
Microsoft.WindowsAzure;
namespace
ConsoleClient
{
class Program
{
static void
Main(string[] args)
{
string connectionString =
"DefaultEndpointsProtocol=https;AccountName=abc;AccountKey=jsjdsfjgdsfj09===";
var TablesName =
GetTablesNameForAzureSubscription(connectionString);
foreach (var
r in TablesName)
{
Console.WriteLine(r.ToString());
}
Console.ReadKey(true);
}
private static List<string>
GetTablesNameForAzureSubscription(string
connectionString)
{
CloudStorageAccount account =CloudStorageAccount
.Parse(connectionString);
CloudTableClient
tableClient = new
CloudTableClient
(account.TableEndpoint.ToString(),
account.Credentials);
var result = tableClient.ListTables();
return result.ToList();
}
On running of above code you should be getting the table name listed for the
account mentioned in connection string. In this case I have three tables listed
to the account as below,
In this way you can list all the tables name from Windows Azure Storage Account.
I hope this post is useful. Thanks for reading.