In my previous post (http://thinkfirstcodelater.com/blog/?p=3553) I showed you how to use the Windows Azure cross platform command line tools to list the SQL databases for a specific SQL server. In this post I’ll show you how to use the tools to view the details for a specific SQL database.
Once again, just a reminder that I’m using the command line tools on a MacBook Air with OSX (Mavericks) 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 sql db show -h
The azure sql db show commands shows the details of a specific SQL database. To use the command you must provide the following parameter values:
- serverName – the name of the SQL server that contains the SQL database
- databaseName – the name of the SQL database you want the details for
- administratorLogin – the administrator login of the SQL server
- administratorPassword – the administrator password of the SQL server
To view the details of a specific SQL database, enter the following into your CLI, substituting where appropriate:
azure sql db show ‘[YOUR SQL SERVER NAME]‘ ‘[YOUR SQL DATABASE NAME]‘ ‘[YOUR ADMINISTRATOR LOGIN]‘ ‘[YOUR ADMINISTRATOR PASSWORD]‘
I used the following:
azure sql db show ‘woa74eflzv’ ‘my_first_db’ ‘adam’ ‘[MY ADMINISTRATOR PASSWORD]‘
That’s it, pretty straightforward. In my next post I’ll show you how to delete a SQL database using the Windows Azure cross platform command line tools.
Did you know you can try Windows Azure for free for 30 days? Just go to http://aka.ms/thecloud and sign up.