Floating FB popout byF5debug

SQL Azure – Drop a Database in SQL Azure Portal



In this article we are going to see how to drop a database using the SQL Azure Management Portal.


Traditionally dropping a database is quite simple using the SQL Server Management Studio by writing a simple query in the Query Analyzer. But in this article we are going drop a database of the SQL Azure using the online Azure Management Portal.


Let us see the step by step process on how to do it using the Azure Management Portal.


Log in to the Azure portal using the below link. You can see the screen look similar to below



Login to the portal using your Microsoft Windows Live credentials with Azure credentials to the management portal and you will see the screen as shown in the screen below


Now we can see the Database Menu at the bottom left, Click on that will go to the Database Subscription window as shown in the screen below


Clicking on the subscription name will provide the complete details of the server created and the new databases created as shown in the screen below


Now select a particular Server by Clicking on the server name at the Left Menu as shown in the screen below and we can see the information specific to the server with the administrator details as well


Now we can see the different database’s available on a particular server, we now choose the server which is not required and should be dropped. In our sample select LearnAzure database as shown in the screen below


Now to drop the LearnAzure Database select the Drop button on the top menu as shown in the screen below


We will get a prompt as shown in the screen below, Click on DROP if we want to proceed further.


After clicking on Drop button we will see the process executing as shown in the screen below


Once completed we can see the LearnAzure database been removed from the Server list as shown in the screen below



In this article we have seen how to drop a database from the Server using the SQL Azure Management Portal. In our upcoming article we will see how to drop a server step by step

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts


Random Posts

Most Viewed


Total posts: 617This year: 4This month: 2This week: 0Comments: 302

Month List

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter