For Those Building New Apps in the Cloud

Azure Cloud on Ulitzer

Subscribe to Azure Cloud on Ulitzer: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Azure Cloud on Ulitzer: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Azure Authors: Yeshim Deniz, Elizabeth White, Pat Romanski, Zakia Bouachraoui, Nick Basinger

Related Topics: Ubuntu Linux Journal, SEO Journal, Azure Cloud on Ulitzer

Blog Feed Post

Azure CLI Day 29 – mobile table show

bash-azure

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

Screen Shot 2013-10-04 at 9.37.50 AM

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’

Screen Shot 2013-10-04 at 9.41.40 AM

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.

Read the original blog entry...

More Stories By Adam Grocholski

Hey there! My name is Adam Grocholski, and I'm a Technical Evangelist at Microsoft where I spend time focusing on Windows, Windows Phone, and Windows Azure. I live in the frozen tundra of Minnesota and run thinkfirstcodelater.com. You can also follow me on twitter at @codel8r.