Azure Cloud on Ulitzer

In my previous post (http://thinkfirstcodelater.com/blog/?p=3283) I showed you how to list the tables associated with your Windows Azure Mobile Service. In this post I’ll show you how to view the details for a single table in your Windows Azure Mobile Service.

Once again, just a reminder that I’m using the command line tools on a MacBook Air with OSX (Mountain Lion) installed, and I’m using Google Chrome as my default browser. However, the experience should be identical on Windows and Linux as well.

Open an instance of your command line (Terminal, Bash, Command Prompt, etc.) and type the following:

azure mobile table show -h

As you can see the mobile table show command shows the details for a mobile service table. To use the command you need to specify two parameters:

1. The name of your mobile service
2. The name of the table

Now type the following into your CLI, substituting where appropriate:

azure mobile table show ‘[YOUR MOBILE SERVICE NAME]‘ ‘[YOUR TABLE NAME]‘

In my case I entered the following:

azure mobile table show ‘zumo-00005′ ‘GenreMovie’

The detailed information returned for the table includes:

• The table’s statistics, including number of records in the table.
• The table’s operations. This shows each CRUD operation (insert, read, update, delete) the permission associated with the operation, and whether or not a custom script has been defined for the operation.
• The table’s columns. For each column in the table, your are given the name, data type, and whether or not the column is indexed.

That’s it for now. In the next post I’ll show you how to update a table in your Windows Azure Mobile Service.

Did you know you can try Windows Azure for free for 30 days? Just go to http://aka.ms/thecloud and sign up.