Floating FB popout byF5debug

SQL Azure – Creating New Views in Azure Portal

 

Introduction:

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

Overview:

Creating view in traditional SQL Server database locally is a simple task, similarly creating view in SQL Azure is easy and simple. SQL Azure provides the new interface to create the Views for the tables created on the SQL Azure database.

[more]

Let us see on the steps to create new Views in Azure portal.

Steps:

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

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

clip_image002

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

clip_image004

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

clip_image006

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

clip_image008

Now we have a database created(LearnAzure) with a Max size of 1GB and ready to use it for 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

clip_image010

Check my previous article on how to connect to the manage portal using the credentials and the firewall using the link. Once logged in you screen will look like below

clip_image011

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 on how to create table using the link). Now your screen will look like below

clip_image012

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 save button navigate to New query windows and write a select statement to query the view as shown in the screen below

clip_image013

We can create as many views as per the requirement and use it across the database.

Conclusion:

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

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

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

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