C#動態操作SQL的方法!

剛寫到一個程式,需要對SQL裡面添加資料庫和表.在網上找的資料不太全.特整理了一下.詳細資料如下:
 //__________________建立資料庫____________________
            string ConnectionString = "Data Source=localhost;Integrated Security=True;Pooling=False";
          SqlConnection conn = new SqlConnection(ConnectionString);           
          conn.Open();    
            sql = "CREATE DATABASE clsky on primary(name = abc ,filename = 'e:\\clsky.mdf')";
   SqlCommand  cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            MessageBox.Show("建立資料庫成功!");
            //_________________________________________________

            //________________建立表___________________________

            string ConnectionString1 = "Data Source=localhost;Initial Catalog=clsky;Integrated Security=True;Pooling=False";
            SqlConnection conn1 = new SqlConnection(ConnectionString1);
            conn1.Open();
            sql = "CREATE TABLE clsky"+
    "(Id INTEGER CONSTRAINT PKeyMyId PRIMARY KEY,"+
    "Name CHAR(50), Address CHAR(255), Balance FLOAT)"; 
      SqlCommand    cmd1 = new SqlCommand(sql, conn1);
     cmd1.ExecuteNonQuery();
           MessageBox.Show("建立資料庫成功!");
            //__________________________________________________

            //_______________刪除表_____________
         
           sql = "DROP TABLE clsky";
           SqlCommand cmd2 = new SqlCommand(sql, conn1);
           cmd2.ExecuteNonQuery();
           MessageBox.Show("刪除表成功!");
           conn1.Close();
           conn.Close();
            //_________________________________
你如果還要刪除此資料庫.可以使用:
    string ConnectionString = "Data Source=localhost;Integrated Security=True;Pooling=False";
            SqlConnection conn = new SqlConnection(ConnectionString);
            conn.Open();
            string sql = "DROP DATABASE clsky  ";
            SqlCommand cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();