syntaxhelp.com Your online cheat sheet!

Creating table using SQL Azure

using System.Data;
using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
    {
//stoaxy9 - unique server that is generated automatically for your account. Make trusted connection to false.  
        string sConn = "Server=tcp:stoaxy9.database.windows.net;
        Database=TestDB;
        User ID=Hima; Password=password;Trusted_Connection=False";
        SqlConnection objConn = new SqlConnection(sConn);
        objConn.Open();

string sSQL = "CREATE TABLE SyntaxHelpTestTable 
( FirstName varchar(50) NOT NULL, LastName  varchar(50) NULL, 
CONSTRAINT PK_TestTable PRIMARY KEY (FirstName) )";

        SqlCommand objCmd = new SqlCommand(sSQL, objConn);
        objCmd.CommandType = System.Data.CommandType.Text;
        objCmd.ExecuteNonQuery();
        objConn.Close();
    }