One way to manage SQL Azure database is through SQL Server Management Studio. Using the Azure web portal, you can also management the following database operations:
- Create and modify tables
- Program Stored Procedures and functions
- Import and export data
- Write and execute SQL statement
We will walk you through how to perform some of these tasks. After you have created a Windows Azure subscription and setup initial database, you can log into the account from this location:
Click on Portal. This will open up a new window shown below. Here is a screenshot of what it looks like:
Go ahead and enter the username and password information. This will connect you to your Azure subscription. Go ahead and expand Subscriptions > Kash LLC > mn51jiybe4 (left navigation bar). Next select Database from the left navigation. We choose Northwind database and select Manage from the top menu.
Here is a screen of what it looks like on our end:
This will launch the SQL Azure login screen. Go ahead and enter the database user credentials. These are different than the Windows Azure login credentials. We have included a figure right below.
Here is what it looks like on our end:
This launches screen of Database Properties with basic summary information. Here is what it looks like:
Select Overview from the left pane and choose Design database from the middle screen. Using this option, you will be able to modify database objects including:
- Stored Procedures
Now you can see the Tables option selected on the top. Right below you can see the different tables in Northwind database. You can design the table here and even create a New table if you like.
Here is a screen capture from our computer:
Next we select the Stored Procedures option. We highlight this proc PROC_CUSTOMER and choose Design. It will open up a new window where you have the ability to design the procedure using TSQL code. You can see input parameters and the actual code.
Here is a screenshot of what it looks like:
Using the SQL Azure portal, you can also write and execute Transact SQL (TSQL) statements. Lets say you would like to write a SELECT statement. We do that on Customers table and here is the SQL statement.
SELECT * FROM CUSTOMERS