SQL Azure - Drop a Database in SQL Azure Portal

Introduction:

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

Overview:

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 will drop a database from SQL Azure using the online Azure Management Portal. Let us see the step by step process of how to do it using the Azure Management Portal.

Steps:

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

http://www.microsoft.com/windowsazure/

image

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.

screenshot_02

Now we can see the Database Menu at the bottom left; click on that to go to the Database Subscription window as shown in the screen below:

image

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:

image

Now select a 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.

image

Now we can see the different databases 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:

image

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

image

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

image

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

image

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

image

Conclusion:

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