SQL azure (6) Use Project Houston to manage SQL azure

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

This chapter is a supplement to SQL azure's use of SQL Server Management studio to connect to SQL azure.

 

On the Windows azure user management page, select an SQL azure database and click the manage button on the toolbar to go to the project Houston Management page.

Project Houston is a Silverlight-based SQL azure Database Manager. Its Interface and functions are similar to SQL Server manaement Studio (SSMs) and are mainly used to manage tables, views, and stored procedures of SQL azure databases. However, SSMs can only be operated through a T-SQL, while project Houston provides a visual approach.

After entering the project Houston, you must first enter the user name and password

After successful logon, the main interface of the Project Houston is displayed. The left-side Navigation Pane lists all tables, views, and stored procedures in the current database. The intermediate section displays the current database configuration information, including the character set, Creation Time, And version information, as well as the current database capacity and usage. The Toolbar contains operations on various databases.

 

Select "design" --> "create table" in the navigation bar ".

You can create a table in SQL azure and add/delete fields, set the type, primary key, and whether the fields are empty.

You can also edit an existing data table.

You can edit and delete existing columns.

As you can see, project Houston provides developers with the function of graphical Management of SQL azure. It can manage tables, views, and stored procedures in the SQL azure database, or view records in SQL azure.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.