.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> Azure >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Creating New Views in Azure Portal in SQL Azure

Posted By:Karthikeyan Anbarasan       Posted Date: June 27, 2011    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

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

 

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.
 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend