.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

Azure Part 28: SQL Azure Management Portal - Create Database and Table

Posted By:Jean Paul       Posted Date: January 28, 2012    Points: 200    Category: Azure    URL: http://www.dotnetspark.com  

SQL Azure Management Portal - Create Database and Table
 

In the previous article we have seen how to connect and create database using the SQL Server Management Portal application.  In this article we can explore how to create create table, views, run sql queries on it etc.

 

Login to SQL Azure Management Portal

 

We need to sign in to the SQL Azure Management Portal before continuing with the topics.  Use the database url for signing in. (eg: https://server.database.windows.net)

 

Creating Table

 

Now we can explore how to create a table using the management portal.  After selecting the database, click on the New Table button to get the table creation screen.

 

 

Within a few seconds you will get the following screen for table creation.  Enter the table details.  I have named the table as Car and entered 3 columns.

 

 

Click on the Save button to save the table.

 

 

The left side tree view provides access to all tables, views and stored procedures in the current database.

 

 

For accessing the table, click on the Tables item as shown above.

 

 

Click on the Data button from the Car table row to view the data inside it.

 

 

We can use the Add Row button to create new rows in the table.  After entering the records, use the Save button to commit the changes.

 

 

Note: Without using the Save button the records will not be saved in the database.  This is an important point in dealing with data.

 

Creating Views, Stored Procedures

 

Similar to the way of table creation, we can create Views and Stored Procedures using the ribbon toolbar buttons.

 

For creating views, use the New View button.

 



For creating stored procedures, use the New Stored Procedure button.

 

 

Query Execution

 

You can write and execute SQL query on the database using the New Query button from the ribbon toolbar.

 

 

On clicking the button, the following query window appears.

 

 

Enter the query "SELECT * FROM Car" and click the execute button.  You will see the results as shown below.  (If you cannot see the results, make sure you clicked the Save button in the record creation screen)

 

Summary

 

In this article we have explored table creation, running sql query on the SQL Azure Management Studio web application.


 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