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