SQL Azure - Creating New Views in Azure Portal


Introduction:


In this article we are going to see how to create a new View using the Management Portal in SQL Azure.

Overview:


Traditionally, creating a view in a SQL Server database locally is a simple task; similarly creating a view in SQL Azure is easy and simple. SQL Azure provides the new interface to create the views for the tables created in the SQL Azure database. Let us see the steps to create new views in Azure portal.

Steps:


Log in to the Azure portal using the link below. You will 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 database created as shown in the screen below:
image
Now we have a database (LearnAzure) created with a maximum size of 1GB and ready for use by the application based on the requirement. To create a new View click on Manage at the top menu tool bar as shown in the screen below:
image
Check my previous article on how to connect to the manage portal using the credentials and the firewall using the link. Once logged in your screen will look like below:
image
Now click on the New View Menu at the top menu to create a view for the table Empdetails which we created in our earlier articles (check my articles to see how to create a table using the link). Now your screen will look like below:
image
Once we created the body of the view as per the requirement, we can save the view and use it by querying in the query analyzer. After clicking on the Save button navigate to New query windows and write a select statement to query the view as shown in the screen below:
image
We can create as many views as needed and use them across the database.

Conclusion:


So in this article we have seen how to create a new view using the SQL Azure Management portal.