use the ExecuteNonQuery() method to run DDL statements

image_pdfimage_print
   


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

class ExecuteDDL
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

    mySqlCommand.CommandText =
      "CREATE TABLE MyEmployee (" +
      "  ID int CONSTRAINT PK_Persons PRIMARY KEY," +
      "  FirstName nvarchar(15) NOT NULL," +
      "  LastName nvarchar(15) NOT NULL," +
      "  DateOfBirth datetime" +
      ")";

    mySqlConnection.Open();

    Console.WriteLine("Creating MyEmployee table");
    int result = mySqlCommand.ExecuteNonQuery();
    Console.WriteLine("mySqlCommand.ExecuteNonQuery() = " + result);

    mySqlCommand.CommandText =
      "ALTER TABLE MyEmployee " +
      "ADD EmployerID nchar(5) CONSTRAINT FK_Persons_Customers " +
      "REFERENCES Employee(ID)";

    Console.WriteLine("Altering MyEmployee table");
    result = mySqlCommand.ExecuteNonQuery();
    Console.WriteLine("mySqlCommand.ExecuteNonQuery() = " + result);

    mySqlCommand.CommandText = "DROP TABLE MyEmployee";

    Console.WriteLine("Dropping MyEmployee table");
    result = mySqlCommand.ExecuteNonQuery();
    Console.WriteLine("mySqlCommand.ExecuteNonQuery() = " + result);

    mySqlConnection.Close();
  }
}